Forum Discussion
Helper IIIRunning total values and value for future periods
I couldn't make it work because future dates were not included so the measures didn't know what to do. I solved it by adding a manual table with future dates, appending this new table with my FactTable, adjusting the measures and voila!!!
i guess it's not the best and tidiest way of doing it but it works so far
Helper IIIHi Ashish_Mathur ,
done!! it kind of works but the flat segment on the last days is that the initial value level instead of the last value level. See pbix file
https://drive.google.com/file/d/1bKbBZQ3k1Ql1jgDYztiXmRtxOzROD1F_/view?usp=sharing
thanks again!!!!!
Helper IIII couldn't make it work because future dates were not included so the measures didn't know what to do. I solved it by adding a manual table with future dates, appending this new table with my FactTable, adjusting the measures and voila!!!
i guess it's not the best and tidiest way of doing it but it works so far