topic Re: Help With creating a caclulation when data is all dated monthly in DAX Commands and Tips

Help With creating a caclulation when data is all dated monthly

JSmart913 — Tue, 04 Feb 2025 15:47:13 GMT

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?

Re: Help With creating a caclulation when data is all dated monthly

Greg_Deckler — Tue, 04 Feb 2025 15:50:09 GMT

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

Re: Help With creating a caclulation when data is all dated monthly

JSmart913 — Tue, 04 Feb 2025 16:39:44 GMT

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

Re: Help With creating a caclulation when data is all dated monthly

JSmart913 — Tue, 04 Feb 2025 16:40:19 GMT

Re: Help With creating a caclulation when data is all dated monthly

Anonymous — Wed, 05 Feb 2025 05:22:12 GMT

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.