Forum Discussion
Combining multiple columns into one measure - Time Intelligence
Hello all, I am new to these forums but have been using Power BI for a number of years. I have a complex data set where I am trying to combine multiple MTD Balance Columns into one measure th...
lbendlin
Super User
Super UserPlease provide sanitized sample data in usable format (not as a picture - inserting it into a table would be good) and show the expected outcome.
Of course.
Sanitized sample (Data is sanitized and simplified - Weekends are excluded as it will be in my data):
Date MTD1 MTD2 MTD3 MTD4 4/26/2021 100 105 114 180 4/27/2021 100 105 114 182 4/28/2021 100 105 114 189 4/29/2021 100 105 114 199 4/30/2021 100 105 114 201 5/3/2021 100 105 114 201 5/4/2021 100 105 114 201 5/5/2021 100 105 114 223 5/6/2021 100 105 114 223 Expected result (for any date after 5/4/2021):
A single MTD measure where when a slicer selects January, 100 is pulled in (the most recent MTD1 value), February - 105, March - 114, and April - 223.
If you need additional or more detailed information, please let me know.
Thank you.
