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, I'm new in Power BI, and I try to see any method if I want to see the list of value are there never reaching zero in weekly.
The table will shown below:
Timestamp | Type | Value |
5/5/22 | Basement | 60 |
5/5/22 | Basement | 50 |
7/5/22 | Basement | 0 |
8/5/22 | Washer | 60 |
4/5/22 | Washer | 70 |
So the result will tell me at that week, washer never reach zero in dashboard.
Thanks for your help.
Solved! Go to Solution.
@Kim_Sky
Here is a link to download a sample solution file:
dax filter non zero 2022-08-08.pbix
@Kim_Sky
Here is a link to download a sample solution file:
dax filter non zero 2022-08-08.pbix
@SpartaBI, for the week num how can I modify that last 7 days
@Kim_Sky saw you asked a question before accepting. You managed this question issue?
@Kim_Sky
my pleasure 🙂
Check out my showcase report - got some high level stuff there. Sure you will find there a lot of cool ideas. Please give it a thumbs up over there if you liked it 🙂
https://community.powerbi.com/t5/Data-Stories-Gallery/SpartaBI-Feat-Contoso-100K/td-p/2449543
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 |
---|---|
42 | |
21 | |
21 | |
14 | |
13 |
User | Count |
---|---|
43 | |
36 | |
33 | |
18 | |
18 |