Forum Discussion
Solved
Percentage Difference always blank
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
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-5c3243d1f9
Appreciate your Kudos.