cancel
Showing results for
Did you mean: New Member

I have a table in fact that I have a calculation of a KPI, in the DAX view I need to return the result of the previous axis as shown in the image below from a dimension table.

Example, 2021 Q3 the KPI2 line returns the result of 2021 Q2 I used a form of rank to find the previous value with reference to rank -1, but I couldn't find any solution.

1 ACCEPTED SOLUTION  Community Support

Hi, @Talesfg ;

You can use the Label_ period column directly, without the aid of rank. Please try it.

``````KPI 2 =
CALCULATE (
SUM ( [KPI] ),
FILTER (
ALL ( 'Table' ),
[label_ period]
= MAXX (
FILTER ( ALL ( 'Table' ), [label_ period] < MAX ( 'Table'[label_ period] ) ),
[label_ period]
)
)
)
``````

The final output is shown below: Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

4 REPLIES 4  Community Support

Hi, @Talesfg ;

You can use the Label_ period column directly, without the aid of rank. Please try it.

``````KPI 2 =
CALCULATE (
SUM ( [KPI] ),
FILTER (
ALL ( 'Table' ),
[label_ period]
= MAXX (
FILTER ( ALL ( 'Table' ), [label_ period] < MAX ( 'Table'[label_ period] ) ),
[label_ period]
)
)
)
``````

The final output is shown below: Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. New Member

@v-yalanwu-msft,

Thank you very much, it worked perfectly.

Ps. Talesfg  Super User

@Talesfg , you need to create a dense rank on period label  or order KPI and prefer that to be in separate column along with base column, joined to this table

example

new column

Qtr Rank = RANKX(all('Date'),'Date'[Qtr Start date],,ASC,Dense)

Measure
This Qtr = CALCULATE(sum('Table'[Qty]), FILTER(ALL('Date'),'Date'[Qtr Rank]=max('Date'[Qtr Rank])))
Last Qtr = CALCULATE(sum('Table'[Qty]), FILTER(ALL('Date'),'Date'[Qtr Rank]=max('Date'[Qtr Rank])-1))

The approach which we follow on week or custom months

Dashboard of My Blogs !! Connect on Linkedin

Learn Power BI Beginners !! Advance Power BI Concepts !! Power BI For Tableau User !! Learn Power BI in Hindi !!
Proud to be a Super User! New Member

Thank you very much, this solution also worked.   