Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I think my model set up is causing issues in PREVIOUSMONTH measure?
My tables, measures must be kept in a separate table
My connections
Fact table contains Case #, date opened, date closed and other information
Fact table connects DateClosed and Date Opened back to Full Date in Ref Caledar to get # of cases open and # of cases closed
When I created 'Previous Month Measure' the numbers are correct, however, shifted a month ahead rather than a month behind.
Hi,
Share the download link of the PBI file. Show the problem very clearly and also the expected result.
I cannot share it, I will create a mock up tomorrow then share