Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
MrToast20
Frequent Visitor

MoM calculation help

I am trying to create a MoM calculation but the result is incorrect.

 

Background

Data files are generated each month and imported to sql.
The test dataset is for Jan & Feb data files

The Feb datafile includes all the Jan data + feb
The data has a column dataFileCreationDate

For Jan the dataFileCreationDate is 31012024

For Feb the dataFileCreationDate is 29022024

Each data row has a processDate which is the date the transaction was processed on the source system

Each data row has a UWYear column which is the year of the transactions inception.  This is a slicer on the page

Both datasets include record with processDates back to 2020

 

dates[Date] is the dates table and is related to items[dateFileCreationDate]

The page has a filter where date = 29/02/2024

 

 

Measure

Prior Month Cost = CALCULATE(Sum('Items'[Cost), PREVIOUSMONTH(dates[Date]))

issue
Prior Mont Cost is correct when the slicer has the current UWYear selected - 2024. 
If I select a different UWYear in the slicer, e.g 2023, the calculation is incorrect as it includes transactions that were processed in feb24.  it should only include those from the previous month - Jan24.
 
Guessing I have something not linked correctly here, any help appreciated.

 

Thanks

 

1 ACCEPTED SOLUTION
MrToast20
Frequent Visitor

This turned out to be a data anomality when reconciling reports. This can now be closed

View solution in original post

2 REPLIES 2
MrToast20
Frequent Visitor

This turned out to be a data anomality when reconciling reports. This can now be closed

lbendlin
Super User
Super User

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information or anything not related to the issue or question.

If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.