Help With creating a caclulation when data is all dated monthly

[JSmart913]

I have a census flat file that is updated monthly - So for 2025 all the january dates on the data say 1/1/2025 and then Feb. will have  data but the date will be 2/1/2025 and so on showing the changes in different accounts each month.  So i want to create a calculation for that year over year growth change for 2023-2024.  So I would need to create the calculation based on the data in the latest data dump for each year 12/1/2023 and 12/1/2024.  How would I do that given that I only want to look at the data from the december time frame?

[Anonymous · Accepted solution]

Hi @JSmart913 ,

Please refers to the following steps.

The test data is as follows.

Create a measure to be used for calculating percentage growth.

Percentage growth =
VAR previousYearValue =
    CALCULATE ( SUM ( 'Table'[Value] ), SAMEPERIODLASTYEAR ( 'Table'[Date] ) )
VAR currentYearValue =
    SUM ( 'Table'[Value] )
RETURN
    DIVIDE ( currentYearValue - previousYearValue, previousYearValue )

Adding this measure to the matrix resulted in the following. Hopefully it will meet your needs.

Please see the attached pbix for reference.

Best Regards,
Dengliang Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Greg_Deckler]

@JSmart913 I would think you would just filter the data coming in so that only December is included in each table.

[JSmart913]

Right but how would i show the % change year over year since it is the same field.  I would need to take the data from 12/1/2023 lets say it was 93 and do a calculation to show the growth to the 12/1/2024 data  151 (so ((151-93)/93) - being a 62.3% increase

[JSmart913]