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!
Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.