Forum Discussion
Comparison Week over week trend
Hello All,
I Have created week over week trend comparing current week with previous week, due to decimal not trend is not giving result.
Please find the below measures used to calculate trend.
Current week DACH WOW trend was suppose to be "--", but it is showing up arrow "▲" due to 0.4% difference comparing previous week.
when every there is 0% in difference (0.1% to 0.9%) trend should show as "--".
Thank You
Regards,
4 Replies
harirao 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.harirao ,Can you share sample data and sample output in table format?
refer if these blog on week can help
https://medium.com/@amitchandak.1978/power-bi-wtd-questions-time-intelligence-4-5-98c30fab69d3
https://community.powerbi.com/t5/Community-Blog/Week-Is-Not-So-Weak-WTD-Last-WTD-and-This-Week-vs-Last-Week/ba-p/1051123Hello amitchandak ,
Thanks for your response, I am able to do week over week comparing, challenge over trend arrows not able to match on Decimals. example mentioned above for DACH
Can you please help on that.Thank You
Regards,
harirao
Not really clear about your question, the difference for DACH WOW is +0.4 so increase. Please provide some sample data if you say it should be 0% and "--".Regards
Paul
