Forum Discussion

ktipton's avatar
ktipton
Frequent Visitor
4 years ago
Solved

Dax Commands with Date vs Days

I am trying to get the Number of Days between two Dates, then if <= 30, I want the Original Amount to show in the New Current Column.  If >= 30 AND <=60, then the Original Amount show in the New 31-6...
aging
Date DIFF
  • v-yanjiang-msft's avatar
    v-yanjiang-msft
    4 years ago

    Hi ktipton ,

    According to your description, here’s my solution.

     

    Best Regards,
    Community Support Team _ kalyj

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-yanjiang-msft's avatar
v-yanjiang-msft
Icon for Community Support rankCommunity Support
4 years ago

Hi ktipton ,

According to your description, here’s my solution.

 

Best Regards,
Community Support Team _ kalyj

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • ktipton's avatar
    ktipton
    Frequent Visitor
    4 years ago

    This was exactly what I needed.  THANK YOU so much!!