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 IIIdidnt give access to all with the link. sorry
please try again: https://drive.google.com/file/d/1ynTnYK1FaCR-vPr5h8z6zEBfo_4lyddo/view?usp=sharing
Super UserHi,
- Create a relationship (Many to One and Single) from the Posting Date column of Table to the Date column of the DateTable.
- Create the WorkDayPeriod column in the DateTable
- In the Table visual, drag the WordDayPeriod and Date columns from the DatTable
Make these changes and share the link of the revised PBI file.
- nicoenz
Hi 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!!!!!
- nicoenz
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