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

OwenAuger's avatar
OwenAuger
Icon for Super User rankSuper User
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

Just wanted to say thanks OwenAuger for your solution . Saved me lot of anxiety and time :)