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.
Hello all
I hope you can give me help
I would like to show running totals, but only until the last call. So my matrix shows below, so if nothing happened on 03/01/2019 then it stays blank
Date Running Total
01/01/2019 10
02/01/2019 25
03/01/2019
04/01/2019 47
05/01/2019 63
My current measure
Just Use this
IF(logical_test>,<value_if_true>, value_if_false)
and replace your blank with 0.
Your Graph will render with no error.
HI,@Anonymous
Use
Hello Nahid
I'm using the same formula already as you suggested. Which works if I want to populate the blank dates, but I want to show when no sales appear. So the 03/01/2019 appears as blank
Thanks
Joe
I solved it by using the dates in the call's table instead of the date table
thanks
Hi PoweredOut,
It seems that you solve this problem, right?If so and if you'd like to, you could mark corresponding post as answer or share your solutions. That way, people who in this forum and have similar issue will benefit from it.
Best Regards,
Zoe Zhi
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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 |
---|---|
112 | |
99 | |
73 | |
72 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |