Forum Discussion

rsbin's avatar
rsbin
Community Champion
3 years ago

CurrentYear - Last Year

Good Afternoon, It's been a while since I have had to do any DAX.  For some reason, I am getting myself all twisted up with this one. I have a Measure to calculate [Selling Profit] YTD: Sellin...
Need Help
rsbin's avatar
rsbin
Community Champion
3 years ago

Padycosmos ,

So using the TotalYTD function, I was able to replicate the results I had in my original post.  So I am no further ahead at this point.  Still unable to resolve my first issue of restricting the max date to today.

Any advice?

Padycosmos's avatar
Padycosmos
Solution Sage
3 years ago

You may please try this

CY YTD = TOTALYTD([Total Sales],Orders[Order Date],Orders[Order Date]<TODAY())
  • rsbin's avatar
    rsbin
    Community Champion
    3 years ago

    Padycosmos ,

    Nope, unfortunately, that doesn't work.  I lose my Cumulative Results and it just gives me one number (i.e $3.5M for all dates ).

     

    • Padycosmos's avatar
      Padycosmos
      Solution Sage
      3 years ago

      Instead of using the Date column from the Dimtime table, could you please try using the Date from the Fact table?