Forum Discussion
FillDown function based on a measure
Hey! I am creating a dashboard that gives an overview of the current states of transaction accounts and it has to show every day (not just the current day). To create this we get information fro...
v-lid-msft This does not work as it messes with the cumulative function (I now see the final value of today in every cell and the cells with no transactions are still empty)
v-lid-msft
Community Support
Community SupportHi Anonymous ,
Have you tried to use the date column in the new calculated table as the row fied instead of using the one in origin table?
Best regards,
v-lid-msft Yes! This changes the data in the cumulative sum measure... And it still leaves me with empty cells! We think this is because not all dates are available in the database (only the one's transactions took place on) and there is no date dimension...
We created a date dimension with a measure, but this also messes with the numbers in the cumulative sum.