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 all
Kindly need your help when I calculate %diff always blank when value on previous day is 0
it should be 100% from image above
Kindly help
thanks
Solved! Go to Solution.
sorry @Greg_Deckler & @amitchandak for not clear, and this issue has been solved to handling blank value when divide 0
thanks all and sorry for inconveniences
sorry @Greg_Deckler & @amitchandak for not clear, and this issue has been solved to handling blank value when divide 0
thanks all and sorry for inconveniences
@zaidkhusain , The information you have provided is not making the problem clear to me. Can you please explain with an example.
If you are looking to take diff % between last date and this date, check the method given in
Power BI — Day Intelligence Questions — Time Intelligence 5–5
https://medium.com/@amitchandak.1978/power-bi-day-intelligence-questions-time-intelligence-5-5-5c324...
Appreciate your Kudos.
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882
Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.
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 |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |