Forum Discussion

JP007's avatar
JP007
New Member
3 years ago

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 m...
Need Help
v-zhangti's avatar
v-zhangti
Icon for Community Support rankCommunity Support
3 years ago

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.