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 Guys,
I am new to Power BI and I have some issues with my current dashboard.
Please see the screen shot below:
In the current year for two dates there was no revenue registered for two dates 16-1-22 and 23-1-22. I did some research on the Power Bi forum on how to solve this, but I did not manage to find how I can solve this type of issue. The "Omzet YTD Last Year" is the correct.
The DAX formulas which I use are the following:
Solved! Go to Solution.
Hi @Vettesnack
For question 1, I think this post by @Greg_Deckler explains the issue you are having: https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376
For question 2, it may have something to do with the nature / way you are using the second measure. If you refer to the above blog by Greg, you should find it resolves the first question and nullifies the second question.
Hope this helps!
Theo 🙂
If I have posted a response that resolves your question, please accept it as a solution to formally close the post.
Also, if you are as passionate about Power BI, DAX and data as I am, please feel free to reach out if you have any questions, queries, or if you simply want to connect and talk to another data geek!
Want to connect?www.linkedin.com/in/theoconias
Hi @Vettesnack
For question 1, I think this post by @Greg_Deckler explains the issue you are having: https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376
For question 2, it may have something to do with the nature / way you are using the second measure. If you refer to the above blog by Greg, you should find it resolves the first question and nullifies the second question.
Hope this helps!
Theo 🙂
If I have posted a response that resolves your question, please accept it as a solution to formally close the post.
Also, if you are as passionate about Power BI, DAX and data as I am, please feel free to reach out if you have any questions, queries, or if you simply want to connect and talk to another data geek!
Want to connect?www.linkedin.com/in/theoconias
Thanks a lot Theo this explains my problem
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 |
---|---|
117 | |
104 | |
77 | |
73 | |
52 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |