Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

help on filtering

hi all, need some advice here on the chart filtering. i have 3 measure calculated using the filtering   next i need to use the above measure to do further % change calculation. however i got bla...
Need Help
Anonymous's avatar
Anonymous
Not applicable
7 years ago

amitchandak but the values are wrong are the new last 12 mths?

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
7 years ago

Calc of 12 month is correct. Currently, the calendar end date is 31-Dec-2019.  So max of that has been taken. Now there two options.

1. when you have a slicer, it will respond to that. I checked it

2. Or in the max, you can use the max of sales date.

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    amitchandak hi,the value of last12 mths is based on all products?

    i tried using adding product filter but the salechange value doesnt change and the last12 mths sale value wrong.

    • amitchandak's avatar
      amitchandak
      Icon for Super User rankSuper User
      7 years ago

      Remove all(DATA1) from the formula. I added that when I did not realize that edit interaction casing issue.

       

       

      Last 12 Mths New = 
VAR _Curr_start = Maxx(dates,DATEADD(STARTOFMONTH(Dates[Date]),-11,MONTH))
VAR _Curr_END =   Max(Dates[Date])
Return
CALCULATE(sum(DATA1[Value]),DATA1[Date]>=_Curr_start && DATA1[Date]<=_Curr_END)

       

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        amitchandak 
        I not sure where i gone wrong, but i cant get the value for last12mth correctly.

        I am trying to get product A, Jan to Dec 2018 sale total = 824
        Can you advice? Thanks so much.

        https://gofile.io/?c=gGH9t0