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

FranzL's avatar
FranzL
New Member
5 years ago

Hi Owen

I had the same probleme and it caused me quite a headache. 

Your solution helped me a lot. Many thanks for that.

All I need to do now is to understand the mechanics properly.

Thanks again.