Forum Discussion
Help! How do I roll forward the latest value
Hi ,
I have created a date ([Calendar]) in the Calendar table, and changed the column format, as below:-
and, there is a date column in my result table as well:-
when I tried to link these 2 columns, the relationship automatically changed to the Result table filter Calendar table again with Many to one cardinality. ðŸ˜ðŸ˜
Super UserHow very strange. I cannot replicate this behaviour, when I use your code it still allows me to create proper one-to-many relationships in the right direction.
The only thing I can suggest is to modify your code a little. You don't need to add the [Calendar] column as the CALENDAR function already gives you a [Date] column. Also, there is no need for the SUMMARIZE - the table is already at the granularity of one day, which is what you need, so there is nothing for SUMMARIZE to do.
Hi,
Thanks for the suggestion. This is the relationship auto-corrected by the PBI.
I got a better result displayed, however, still not what I am looking for, for example, 1.99 should carry forward to 202307 till 202403 and 1.22 from 202404 till 202412, however, this is not happening with this DAX formula. It displayed with the Max value 2.33 instead. Any idea how this can be adjusted? Thanks for your help.