Comparison Week over week trend

[harirao]

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.

test_Wow2 = Query1[> 6 Weeks Visibility % of Regional Total]-[Test WOW2]

WOWTrend2 = IF([test_Wow2]<0,"▼",IF([test_Wow2]>0,"▲","--"))

ColorCode2 = if(Query1[test_Wow2]<="--",0,if(Query1[> 6 Weeks Visibility % of Regional Total]=0,0,if(Query1[test_Wow2]="▲",1,-1))) //(Conditional formatting for WOWTrend2)

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,

[V-pazhen-msft]

@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

[amitchandak]

@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-La...

[harirao]

Hello @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,

[Greg_Deckler]

@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.