I've got these 2 tables:
Report needs to be:
So, if a date is missing, the latest value must be taken.
I prefer to use dax for this.
Anyone has a suggestion?
Go to Solution.
Try this MEASURE
SUM ( 'fact'[stock] ),
ALLSELECTED ( 'Calendar'[Datekey] ),
'Calendar'[datekey] <= SELECTEDVALUE ( 'Calendar'[datekey] )
CALCULATE ( SUM ( 'fact'[stock] ) )
View solution in original post
Check out the on demand sessions that are available now!
Check out the Winners!
Features releasing from October 2020 through March 2021