How to get a YoY % Change Column added to a matrix?

[tridino]

Hi everyone,

I'm new to PowerBi, so please forgive the lack of knowledge here.  I have the following table, which is a summation of inventory items sold.  I would like to add another column added labelled 'YoY % Change' which simply does a percentage change calculation of the different Quarters between the two years.  For example, the % Change of 394 from Q1 2024 and 361 of Q1 2025.

What is the easiest way to do this, considering this matrix is a summation of data? 

Thank you.

[v-prasare]

Hi @tridino,

We haven't heard back from you. Can you please let me know if your issue got resolved or you are still looking for any assistance here.

Thanks,

Prashanth Are

MS Fabric community support

If our super user response resolved your issue, please mark it as "Accept as solution" and click "Yes" if you found it helpful.

[v-prasare · Accepted solution]

Hi @tridino,

As @MasonMA mentioned above, Can you please share the sample data ?

Thanks,

Prashanth Are

MS Fabric community support

If our super user response resolved your issue, please mark it as "Accept as solution" and click "Yes" if you found it helpful.

[v-prasare]

Hi @tridino,

We would like to follow up to see if the solution provided by the super user resolved your issue. Please let us know if you need any further assistance.

@MasonMA , thanks for your prompt response.

Thanks,

Prashanth Are

MS Fabric community support
If our super user response resolved your issue, please mark it as "Accept as solution" and click "Yes" if you found it helpful.

[tridino]

I was not able to get to work.

[MasonMA]

@tridino If your data is not restricted you can share a sample or part of it so we can have a look:) 

[MasonMA]

Hi @tridino 

No problem and thanks for the contexts. There are different ways to create Date table, either through Power Query or Power BI. I would suggest you create it in Power Query by following this video from Bas, 

https://www.youtube.com/watch?v=MhC4zj2byBQ

Once your Date table is created, build a one (Date) to many (fact table) relationship so your Date table can filter your fact table. In the meantime, mark this as your Date table (Under Table tool, Calendar)

If your Total is an implicit measure as you mentioned in your message, i'd suggest you create a calculated measure by simply aggregating it, TotalMeasure = SUM(TableName[Total]),

With all the above done, you can create that earlier YOY% measure i provided to you in the last message and use it in your report:) 

[MasonMA]

Hi, if your Total is already an explicit measure and you have a proper Date table with relationships (suppose your Fiscal year and Fiscal quarter both come from your Date table and it has been marked as Date table), then try this measure below 

YoY % Change  = 
VAR PrevYear =
    CALCULATE (
        [Total],
        SAMEPERIODLASTYEAR ( 'Date'[Date] )
    )
RETURN
DIVIDE ( [Total] - PrevYear, PrevYear )

[tridino]

Hi Mason, can you provide step-by-step for creating the Date Table with relationships and creating the measure? Thank you, I'm very new to data analysis with Power Bi.  My Totals columns are not calculated with any formula - my data set is about 9000 rows and it's just a count of the values by using a matrix table on the Report View. Here's an example of how it's structured: