Forum Discussion

PavelR's avatar
PavelR
Icon for Solution Specialist rankSolution Specialist
9 years ago
Solved

YTD last year DAX

Hi,   I have question about YTD Last year DAX formula. Even though I have read many blogs and topics here in community, I still don't know how to solve this issue. Suppose I have data like below. ...
Need Help
  • OwenAuger's avatar
    OwenAuger
    9 years ago

    PavelR

     

    It should work fine in Power BI.

    You didn't have any dates in your Data table beyond 3 Jan 2017 did you?

     

    Here is a sample PBIX file with your data posted above where the measure is working:

    PBIX file

     

    I made a small change to the YTD measure so that it is not displayed after the max date in Data table, but the YTD LY measure is the same as I posted.

     

    Have a play with that - there must be some difference in your model if it is not working.

     

    Owen

Anonymous's avatar
Anonymous
Not applicable
8 years ago

I used the following formula to find YTD and YTD LY

YTD = CALCULATE(SUM('data'[konto]),
FILTER('year',[Date]>=DATE(YEAR(TODAY()),1,1) && [Date]
<=(DATE(YEAR(TODAY()),MONTH(TODAY()),1)-1)))

 

YTD LY = CALCULATE(SUM('data'[konto]),
FILTER('year',[Date]>=DATE(YEAR(TODAY())-1,1,1) && [Date]
<=(DATE(YEAR(TODAY())-1,MONTH(TODAY()),1)-1)))

when I select year 2018 It only showes me YTD, how can I fix this to look both YTD and YTD LY when year 2018 is selected?

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
8 years ago

Hi,

 

What exactly are you trying to do?  Describe your question in detail and share some data.