Forum Discussion
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...
you should be able to just check the menu item from above that states "Don't Summarize".
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!