Forum Discussion

MxJ's avatar
MxJ
Frequent Visitor
7 years ago

Filter on certain filter category

Hi Guys,   I am using a table that shows YTD wholesale growth with the following DAX-query: Wholesale Growth = ([Total Wholesale]-Calculate([Total Wholesale];SAMEPERIODLASTYEAR(Real_date[Date])...
Need Help
v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
7 years ago

Hi MxJ,

 

Can you share a similar sample like mine? Please mask the sensitive parts first.

 

 

Best Regards,

MxJ's avatar
MxJ
Frequent Visitor
7 years ago

My data is the same as your sample. The problem is that I need 2019(-0.9) and Qtr 1(-0.57) to be 0.32,, just like Januari. It sets Februari and march at 0 when calculating their own value but still take them into account when calculating 2019 and Qtr 1.

 

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Microsoft Employee
    7 years ago

    Hi MxJ,

     

    I'm afraid this is what it should be. Let's have a look. The 2019-January means 2019-Jan compares 2018-Jan. The 2019-Qtr 1 means 2019-Qtr 1 compares 2018-Qtr 1. Though the value of 2019-Qtr 1 only has one month, 2018-Qtr 1 has three months value. 

    Then there is a question. How can we know that the 2019-February doesn't have data or it should be 0 (the result is 0)?

     

     

    Best Regards,

  • MxJ's avatar
    MxJ
    Frequent Visitor
    7 years ago

    Hi v-jiascu-msft !

     

    Sorry for my late response, I was on holiday. I guess you are right. I think I will exclude the current year and make a extra button "2019" that will go to a bookmark that shows the same table but with figures per month instead of per quarter, then the numbers do make sense.

     

    If you have a better option though, please let me know! :)