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

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's avatar
    PattemManohar
    Community Champion
    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")))