Get Non-Blank values

[Anonymous]

Hi Team,

How to get non blank values of the previous date in Power BI?

Regards, Pradeep

[Anonymous]

Thanks Manohar.

[Anonymous]

Dear Manohar,

Please see the snapshot attached.

This should be on a monthly basis. We need to consider the non blank values of previous days and roll it up to get the summation.

Regards,

Pradeep

[PattemManohar · Accepted solution]

@Anonymous  Please add this as a New column

RunningTotal = CALCULATE(SUM([Count]),FILTER(Test283RunningTotal,[Date]<=EARLIER([Date]) && FORMAT([Date],"MMYYYY") = FORMAT(EARLIER([Date]),"MMYYYY")))

[PattemManohar]

@Anonymous  Sample test data and expected output please !!