Search:

Type: Posts; User: sadath; Keyword(s):

Page 1 of 6 1 2 3 4

Search: Search took 0.02 seconds.

  1. Replies
    5
    Views
    107

    Re: Excel Weekday Function Issue

    =weekday(Col A,2) returns the week number ie a numeric number 3 (not date its a numeric value)
    then you try to format that number number to date, will return Tue (equivalent date of numeric value...
  2. Replies
    4
    Views
    134

    Re: Combining 3 x INDEX MATCH

    Hi
    here is array formula =VLOOKUP(C4,INDIRECT(INDEX(A1:A3,MATCH(TRUE,COUNTIF(INDIRECT(A1:A3),C4)>0,0))),2,0)

    where A1 has admin!B2:C100
    A2 admin!d2:e100
    A3 admin!f2:g100
  3. Replies
    1
    Views
    732

    Re: Can I Freeze a Slicer

    Hi
    A Slicer cannot float on Excel worksheet, it moves along with the cells.

    you can freeze top few rows and place the slicer in it.
  4. Replies
    0
    Views
    391

    Merge Table with Input Variable

    I have a query which merge a with another query..

    the table which i want to merge is taken from input variable, so the query as given below
    currently Cri value is POSDATA

    error is getting when...
  5. Re: Power Query - Split an amount into multiple rows

    let

    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Invoice number", Int64.Type}, {"Location", type text}, {"Quantity",...
  6. Replies
    3
    Views
    714

    Re: Average with topn

    Hi,
    Thank you very much, that formula works brilliant !!.

    one doubt, what is the difference between
    ADDCOLUMNS ( SUMMARIZE ( Table1, Table1[Parlour] ), "TotSales", [Tot] ) & SUMMARIZE (...
  7. Replies
    3
    Views
    714

    Average with topn

    i have following formula to find the average of top 2 sales in each city

    AvgTopSales:=AVERAGEX(topn(2,summarize(ALL(Table1),Table1[Parlour],"TotSales",[Tot])),[TotSales])

    currently my pivot...
  8. Replies
    2
    Views
    442

    Re: VB Spellnumber code

    Do the changes in line 40 & 42

    Line 40
    Rupees = "Rupee One"

    Line 42
    Rupees ="Rupees " & Rupees
  9. Replies
    5
    Views
    370

    Re: 3 values How to return different value?

    =IF(AND(B2=C2,C2=D2),"nothing",TEXT(D2/B2-1,"#%"))
    % increase/decrease is Mar Price over Jan Price, if not change the formula accordingly
  10. Replies
    1
    Views
    1,640

    Re: Google translate excel vba

    I have found another one but english to arabic is not working.

    any one please fix it


    Function Translate_To_Arabic(Rng As Range) As String
    ' Tools Refrence Select Microsoft internet Control
    ...
  11. Replies
    1
    Views
    1,640

    Google translate excel vba

    Hi

    I use below =Translate() function to translate a text

    the below code works on all language except english to arabic (it works arabic to english)
    what is wrong in this code?? or can...
  12. Thread: Slicer issue

    by sadath
    Replies
    1
    Views
    417

    Slicer issue

    Hi

    I have table with columns Month (1 to 12) & Sales

    in Pivot table Month on rows and Sales on values.

    question : if i select month in slicer (say 3) data should show till month 3
    ...
  13. Replies
    1
    Views
    170

    Vlookup and sum from multiple sheet

    Hi

    what is wrong in the UDF

    Function MLookup(LV As String, Rng As Range, Col As Varient, ShName As Variant) As Integer
    Dim Ans As Integer

    For Each Cl In ShName

    Ans = Ans +...
  14. Lookup and sum using offset in multiple sheet

    Hi
    i use the formula to lookup and sum from a particular sheet

    =SUM(OFFSET(INDIRECT(ADDRESS(MATCH($A6,KSA_ALL!$A:$A,0),1,,,"KSA_ALL")),0,9,1,2))

    where 9 & 2 (OFFSET col & OFFSET width are is...
  15. Replies
    1
    Views
    331

    Invoke function with two parameter

    Hi
    i have made below invoke function (name GETSALES) with two parameter

    (CODE)=>
    (DATE1)=>
    let
    Source = Folder.Files("G:\SALESDATA\SALES\REVIEW\2018\DSR2018\ActualSales"),
    #"Removed...
  16. Thread: Pq merge

    by sadath
    Replies
    1
    Views
    325

    Pq merge

    Hi,
    Assume I have two table to merge in power qurty

    SL Value
    1 350
    2 6545
    4 64
    6 654
    7 464
  17. Replies
    3
    Views
    421

    Re: Column Subtraction

    Hi
    I wrote in my thread, its PQ (Power Query) not excel formula. And this section is only for Power BI

    any one have the answer
  18. Replies
    3
    Views
    421

    Column Subtraction

    Hi,

    I am trying to put a custom column by subtracting Value1 from Value2, Subtraction column is the result i got from PQ
    Store3 result should be -21 (null-21) & Store 5 result should be 54...
  19. Replies
    1
    Views
    797

    Reverse of Fill Down in PQ

    Hi

    How can i do the reverse of Fill Down in PQ.

    ie remove the duplicate and keep only the first one in a column (Eg "Store" in the below code)


    let
    Source =...
  20. Replies
    4
    Views
    703

    Re: Input variable in pq

    Hi
    Thank You horseyride.. Now its working..
  21. Replies
    4
    Views
    703

    Re: Input variable in pq

    Hi
    Still it returns error

    I tried below, that is working

    let
    AddCri = "10 Apr 2018",
    Source = Csv.Document(File.Contents("C:\Users\sadat\Desktop\HD REPORT" & AddCri &...
  22. Replies
    4
    Views
    703

    Input variable in pq

    Hi

    i have made a date input variable as below(query Name DATETABLE which returns correct result eg 10 Apr 2018

    let
    Source = Excel.CurrentWorkbook(){[Name="DATE"]}[Content],
    ...
  23. Replies
    0
    Views
    374

    Table from input variable

    Hi

    I am trying to create a table from date input variable

    PeriodFrom variable

    let
    Source = Excel.CurrentWorkbook(){[Name="Table3"]}[Content],
    #"Changed Type" =...
  24. Thread: Sorting table

    by sadath
    Replies
    1
    Views
    437

    Sorting table

    HI,

    My week name (like Week 1, Week 2, Week 3...) in slicer not showing in the right order, I tried to sort Week by Date in the calendar table
    Error showing that 'at least one value in Week have...
  25. Replies
    1
    Views
    423

    Calculate operating days.

    Hi All,

    how can calculate the operating days

    STORELIST[Start Date] is the store opened date
    STORELIST[End Date] is the store close date
    [NEnd] is Max(Calendar[Date])
    [NSt] is...
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4