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")))

4 Replies

  • 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")))

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Thanks Manohar.:smileyhappy: