Forum Discussion

nlakshmi's avatar
nlakshmi
Frequent Visitor
1 year ago
Solved

Week over Week Diff

Hi,   I have a question on a calculation for week-over-week change. I have the data as below:   Column 1 is the Week Ending Date   Date Name Origin Date Destination Date 6/30/2025 P1 ...
Need Help
  • ryan_mayu's avatar
    ryan_mayu
    1 year ago

    nlakshmi 

     

    you can try to create three measures

     

    Count of NameTotal = COUNTROWS('Table')
     
    Count minus Count of Name with Destination Date = [Count of NameTotal] - CALCULATE(COUNTROWS('Table'),FILTER('Table',not(ISBLANK('Table'[Destination Date]))))
     
    Measure =
    VAR _date = MAX('Table'[Date])
    VAR _list = CALCULATETABLE(
        VALUES('Table'[Name]),
        'Table'[Date] = _date
    )
    VAR _list2 = CALCULATETABLE(
        VALUES('Table'[Name]),
        FILTER(
            ALL('Table'),
            'Table'[Date] < _date
        )
    )
    RETURN if (_date=CALCULATE(min('Table'[Date]),all('Table')),0,countrows(EXCEPT(_list, _list2))+0)


     

    pls see the attachment below

     

    pls see the attachment below

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi nlakshmi ,

 

Thank you Royel  and ryan_mayu  for the response provided!
Has your issue been resolved? If the response provided by the community member addressed your query, could you please confirm? It helps us ensure that the solutions provided are effective and beneficial for everyone.


Thank you for your understanding!