Forum Discussion

GJD23's avatar
GJD23
Frequent Visitor
2 years ago
Solved

Sales Growth issues

Hi there - can anyone let me know where i am going wrong - trying to follow one of Chandeep Goodleys videos but not getting expected results - Prev Date correctly shows the previous date - but the Sa...
Need Help
  • rajendraongole1's avatar
    rajendraongole1
    2 years ago

    Hi GJD23  Great, yes we have to remove the page level filter and check the value. it works as expected worked on similar scenerio. 

    Hope you find it useful.

     

    Did I answer your question? Mark my post as a solution! This will help others on the forum!
    Appreciate your Kudos!!

rajendraongole1's avatar
rajendraongole1
Icon for Super User rankSuper User
2 years ago

Hi GJD23 - the above issue might be due to context within the DAX measure. Calculation should correctly evaluates the sales for the previous date

 

Try the below modified measure for growth test:

 

Growth Test =
VAR PrevDateTest =
MAXX(
FILTER(
ALL(DataFile[Doc. Date]),
DataFile[Doc. Date] < SELECTEDVALUE(DataFile[Doc. Date])
),
DataFile[Doc. Date]
)
VAR PrevSalesTestXX =
CALCULATE(
[Sum of Buy Price],
DataFile[Doc. Date] = PrevDateTest,
REMOVEFILTERS(DataFile[Doc. Date])
)
RETURN
PrevSalesTestXX

 

 

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!