Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi Team,
How to get non blank values of the previous date in Power BI?
Regards, Pradeep
Solved! Go to 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")))
Proud to be a PBI Community Champion
Thanks Manohar.
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
@Anonymous Please add this as a New column
RunningTotal = CALCULATE(SUM([Count]),FILTER(Test283RunningTotal,[Date]<=EARLIER([Date]) && FORMAT([Date],"MMYYYY") = FORMAT(EARLIER([Date]),"MMYYYY")))
Proud to be a PBI Community Champion
@Anonymous Sample test data and expected output please !!
Proud to be a PBI Community Champion
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
99 | |
80 | |
70 | |
59 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |