Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

summing previous year while allowing current year filter power bi

Hello, I'm trying to display current year gained from last years totals.  Table appears as followed: Type Type2   CurrentYrGained        2021Growth          2020Gained(Not displayed but used for ca...
Need Help
  • v-yingjl's avatar
    v-yingjl
    5 years ago

    Hi Anonymous ,

    Put the Year of Date hierarchy in the slicer and select current year, it should work.

    Attached a sample file in the below, hopes it could help.

     

    Best Regards,
    Community Support Team _ Yingjie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-yingjl's avatar
v-yingjl
Icon for Community Support rankCommunity Support
5 years ago

Hi Anonymous ,

Put the Year of Date hierarchy in the slicer and select current year, it should work.

Attached a sample file in the below, hopes it could help.

 

Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

This will work. Its does not allow for "Relative Dates" but, still functions by displaying single year while still doing previous year calcualtion. Also to avoid the infinity return for years that do not have a prior year I've update dax in measure with below.

 

Thank you for you aid. 

 

 

Measure =
VAR test =
CALCULATE (
SUM ( Engagement[Engagement Gains] ),
SAMEPERIODLASTYEAR ( 'Engagement'[Date].[Date] ),
ALLEXCEPT ( 'Engagement', 'Engagement'[Type], 'Engagement'[Type2] )
)
RETURN
IF(test=BLANK()||test<0, 0,
( SUM ( Engagement[Engagement Gains] ) / test ) - 1)