Forum Discussion

Rsanjuan's avatar
Rsanjuan
Advocate III
10 years ago

Help needed for DAX rolling calculation

Last60Days = IF(AND([Date] >= [Today]-60, [Date] <= [Today]),1,0)   I am trying to calculate the rolling number of completed and planned meetings.     For the completed meetings, I'm trying...
Need Help
Rsanjuan's avatar
Rsanjuan
Advocate III
10 years ago

Nhallquist

 

Everything looks ok.

 

Completed60 = sum('Invoked Function'[Last60Days])

PlannedFuture = Sum('Invoked Function'[FutureMeeting])

 

Last60Days = (IF(AND([Date] >= [Today]-60, [Date] <= [Today]),1,0))

FutureMeeting = If([Date]>Today(), 1,0)

 

Is there a way just to not show the Total at all?

 

 

Nhallquist's avatar
Nhallquist
Helper V
10 years ago

you should be able to just check the menu item from above that states "Don't Summarize".  

  • Rsanjuan's avatar
    Rsanjuan
    Advocate III
    10 years ago

    Nhallquist

     

    Now it's just saying 1 or 0 for each one.  saying "true" or "false" that they had that type of meeting in the past 60 days.

     

    I think I have to change the formula in for 

     

    Last60Days = (IF(AND([Date] >= [Today]-60, [Date] <= [Today]),1,0))

     

    FutureMeeting = If([Date]>Today(), 1,0)

     

    Like it meets the Date condition, something like count it, instead of true/false.  Any ideas on the type of formula to use?  Thanks!