Forum Discussion
nicoenz
Helper III
Helper IIIRunning total values and value for future periods
Hi everyone, i have a table that contains Volume data for December and January. As of January 7, there's no more data The running total measure that i use: Running total = var Turro = CALCUL...
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
nicoenzHelper III
Helper IIIHi Anonymous and Ashish_Mathur Ashish
here's the link to the file: https://drive.google.com/file/d/1ynTnYK1FaCR-vPr5h8z6zEBfo_4lyddo/view?usp=drive_link
Thanks for your help!!!!!!!
- Ashish_Mathur
Super User
Access Denied message.
- nicoenz
didnt give access to all with the link. sorry
please try again: https://drive.google.com/file/d/1ynTnYK1FaCR-vPr5h8z6zEBfo_4lyddo/view?usp=sharing
- Ashish_Mathur
Hi,
- 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.
