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

 

I tried it and I got this.  Looks like the account name and their totals are accurate, just the overall quota seems way off.  It's not totaling correctly

 

 

Nhallquist's avatar
Nhallquist
Helper V
10 years ago

Check the settings of your value field, and make sure that some weird setting isn't checked.

 

  • 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!