Forum Discussion
Need help to get lastnonblank value
Hi all, looking for some help here... i just can't figure it out.
I need to show the total for days that I don't have a value using the last available balance.
i.e. January 3 should be showing me $81,759,015.35 since it's the last available balance. LastBalanceID is a measure which is:
LastBalanceID = CALCULATE( SUM (DepositData[Balance]), LASTDATE( 'Dates'[Date]) )
I do have a calander table that I'm using for the table below, instead of using DepositData[Date]
Thank you
2 Replies
v-zhangtiCommunity Support
Hi, JP007
You can try the following methods.
Measure:LastBalanceID = CALCULATE(SUM(DepositData[Balance]),LASTDATE( 'Dates'[Date]) )TestPreviousDay = CALCULATE([LastBalanceID],FILTER(ALL(Dates),[Date]=SELECTEDVALUE(Dates[Date])-1))Measure = IF([LastBalanceID]=BLANK(),[TestPreviousDay],[LastBalanceID]-[TestPreviousDay])Is this the result you expect?
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
