Calculating previous quarter figure in new column

[RichOB]

Hi, how can I get the previous quarter count in a new measure to then calculate the % change from the previous FQ, please? For example, I need a new column called Previous_Count where FY2024 FQ4 shows 119.

This is what I currently have, along with a calendar with the financial year and financial quarter columns:

Thanks for your help

[v-sdhruv]

Hi @RichOB ,

Since we didnt hear back, we would be closing this thread.
If you need any assistance, feel free to reach out by creating a new post.

Thank you

[v-sdhruv]

Hi @RichOB ,

Just wanted to check if you had the opportunity to review the suggestions provided and whether that helped to resolve the issue?

Thank You

[v-sdhruv]

Hi @RichOB ,
Just wanted to check if you had the opportunity to review the suggestions provided and whether that helped to resolve the issue?

Thank You

[v-sdhruv · Accepted solution]

Hi @RichOB ,

You can add an index column like-

Then use this DAX in your calculated column-

Previous = 
CALCULATE(
    MAX('Table'[Count]),
    FILTER(
        'Table',
        'Table'[Index] = EARLIER('Table'[Index],1) -1
    )
)

You will get the previous count.

Attached file for reference.

Hope this helps!

[Jihwan_Kim]

Hi,

One of ways is to use Visual Calculation, and use PREVIOUS function in the formula bar.

Please check the link down below.

Using visual calculations in Power BI Desktop - Power BI | Microsoft Learn