Forum Discussion

saris02's avatar
saris02
New Member
7 years ago
Solved

YTD YA performance

Hi There!   I am struggling with YTD YA measure - I have checked the similar posts, and used the same logic - and if I check the data with power BI publisher for excel, in excel I get incorrect res...
Need Help
  • saris02's avatar
    saris02
    7 years ago

    Hi Lin!

     

    Thanks a lot for your feedback - yesterday evening I managed to fix my problem, and it's working now :)

     

    Have a great weekend,

    Cheers,

     

    Szilvi

v-lili6-msft's avatar
v-lili6-msft
Community Support
7 years ago

HI, saris02

The second formula is to calculate last year's YTD.

and it works well

For example

And if the date hierarchy is include day,  it will calculate the sales from Jan 1 till Dec 31.

 

If it is not your case, please share pbix file or some data sample and expected output . You can upload it to OneDrive or Dropbox and post the link here. Do mask sensitive data before uploading.

 

Best Regards,

Lin

 

 

 

saris02's avatar
saris02
New Member
7 years ago

Hi Lin!

 

Thanks a lot for your feedback - yesterday evening I managed to fix my problem, and it's working now :)

 

Have a great weekend,

Cheers,

 

Szilvi