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:
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!