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
MxJ's avatar
MxJ
Frequent Visitor
7 years ago

Thanks for your reply. 

 

The only problem I have is that the formulas dont work when I use the real_date table is steady of the date from the wholesale table.. It returns "empty" when i use:

Total Wholesale YTD = TOTALYTD([Total Wholesale];'Real_date'[Date]) 

Also,  the figure from januari still does not show at Q1. 2019 gives -0,90 while januari gives 0,32 in your example.

 

I need Q1 and 2019 to say 0,32 as well.

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Icon for Microsoft Employee rankMicrosoft 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
        Icon for Microsoft Employee rankMicrosoft 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,