Forum Discussion

m_wex's avatar
m_wex
Icon for Helper I rankHelper I
5 years ago

Problem with Previous YTD for Ranked Sales

Good Evening All,   Reaching out for help. Having no success solving an issue with calculating previous YTD sales (PYTD). The issue starts with current year sales and trying to match sales for the ...
Previous YTD for Ranked Sales
Jihwan_Kim's avatar
Jihwan_Kim
Icon for Super User rankSuper User
5 years ago

Hi, m_wex 

Please check the below picture and the sample pbix file's link down below.

I tried to create a sample pbix file based on the scenario, and I hope it suits your case.

All measures are in the sample pbix file.

 

 

 

https://www.dropbox.com/s/0akngbte7h692cc/Mwex.pbix?dl=0 

 

Hi, My name is Jihwan Kim.

 

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

 

Linkedin: linkedin.com/in/jihwankim1975/

Twitter: twitter.com/Jihwan_JHKIM

m_wex's avatar
m_wex
Icon for Helper I rankHelper I
5 years ago

Good Evening,

 

Thank you for the post and the sample data set. I am not able to view this yet as the version I am using is not the latest (October 2020) and I need to check with our IT group about updating to the April 2021 version.