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.

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

    Good Evening,

     

    Is it possible to send another version of the sample data? 

    Using version from October 2020.

     

    Thanks,

    M_Wex

    • Jihwan_Kim's avatar
      Jihwan_Kim
      Icon for Super User rankSuper User
      5 years ago

      Hi, m_wex 
      Thank you for your feedback.

      Sorry, and I am not able to downgrade mine.

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

        Is it possible to post the dax formulas? It might be a while before I get my version upgraded.