Forum Discussion
Measure to show zero data where no data for date
Cgull this is a large problem than what looks on the surface, as a best practice, you always want to have dimension in your model and strive for star schema and that's is the root cause of this problem. Understand star schema and the importance for Power BI - Power BI | Microsoft Docs
See attached and now you want to tweak the measure as referred to in the previous reply for the SQLBI video.
✨ Follow us on LinkedIn
Check my latest blog post Comparing Selected Client With Other Top N Clients | PeryTUS I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
Cgull this is a large problem than what looks on the surface, as a best practice, you always want to have dimension in your model and strive for star schema and that's is the root cause of this problem. Understand star schema and the importance for Power BI - Power BI | Microsoft Docs
See attached and now you want to tweak the measure as referred to in the previous reply for the SQLBI video.
✨ Follow us on LinkedIn
Check my latest blog post Comparing Selected Client With Other Top N Clients | PeryTUS I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡