Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Get Non-Blank values

Hi Team,   How to get non blank values of the previous date in Power BI?   Regards, Pradeep
Need Help
  • PattemManohar's avatar
    PattemManohar
    7 years ago

    Anonymous  Please add this as a New column

     

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

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Thanks Manohar.:smileyhappy: