Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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 |
Solved! Go to Solution.
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:
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.