Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Trying to compare the difference between 2 dates recursively?

Hi all I have a list of dates (from a column called Report Dates) and a list of values (result of COUNTA from a column called "Backlog") in a Matrix visual.    I want to add a new row/Value wh...
Need Help
Tutorial Requests
  • VahidDM's avatar
    VahidDM
    4 years ago

    Hi Anonymous 

     

    try this:

    Measure = 
    Var _M = Max(table[Report Dates])
    Var _M1 = calculate(Max(table[Report Dates]),filter(all(table),table[Report Dates]<_M))
    return
    COUNTA(table[Backlog]) - calculate(COUNTA(table[Backlog]),filter(all(table),table[Report Dates]=_M1))

     

    If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
    Appreciate your Kudos!!
    LinkedIn:     www.linkedin.com/in/vahid-dm/

     

     

VahidDM's avatar
VahidDM
Icon for Super User rankSuper User
4 years ago

Hi Anonymous 

 

try this:

Measure = 
Var _M = Max(table[Report Dates])
Var _M1 = calculate(Max(table[Report Dates]),filter(all(table),table[Report Dates]<_M))
return
COUNTA(table[Backlog]) - calculate(COUNTA(table[Backlog]),filter(all(table),table[Report Dates]=_M1))

 

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/

 

 

Anonymous's avatar
Anonymous
Not applicable
4 years ago

That's great, thank you!