Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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
User | Count |
---|---|
93 | |
86 | |
68 | |
62 | |
58 |
User | Count |
---|---|
150 | |
113 | |
95 | |
80 | |
72 |