Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us at FabCon Vienna from September 15-18, 2025, for the ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM. Get registered
Hi everyone, I have a table using measures to create calculated values. Ok, nothing new. The table is organized by a "Month Year" column ( I don't have a date field in the table). I do have a month number column. I want a third column (via a measure) that will replicate the previous month's value. I cant index the table as the Month Year values are not unique. Please see the table below to see what I need. Thank you very much for your help.
Month Year | Measure Value | Previous Measure Value |
Aug 2016 | 25 | |
Sep 2016 | 42 | 25 |
Oct 2016 | 17 | 42 |
Nov 2016 | 36 | 17 |
Dec 2016 | 5 | 36 |
Jan 2017 | 62 | 5 |
everyone, I found a soultion that I want to share... here is the Measure with the working solution:
everyone, I found a soultion that I want to share... here is the Measure with the working solution:
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Fabric update to learn about new features.