Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi Team,
How to find a 20% increase and a 20% decrease in yesterdays and day before yesterdays data In Power BI desktop.
If 20% Increase then displays any text or color and vice-versa.
Thanks,
Arvind
Solved! Go to Solution.
You can create a measure like pattern below and drag the measure to the card visual:
Result = VAR yesterdays_value = CALCULATE ( MAX ( Table[Value] ), FILTER ( Table, Table[Value] = TODAY () - 1 ) ) VAR day_before_yesterday = CALCULATE ( MAX ( Table[Value] ), FILTER ( Table, Table[Value] = TODAY () - 2 ) ) RETURN IF ( yesterdays_value - day_before_yesterday / day_before_yesterday > 0.2, "Text", BLANK () )
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
You can create a measure like pattern below and drag the measure to the card visual:
Result = VAR yesterdays_value = CALCULATE ( MAX ( Table[Value] ), FILTER ( Table, Table[Value] = TODAY () - 1 ) ) VAR day_before_yesterday = CALCULATE ( MAX ( Table[Value] ), FILTER ( Table, Table[Value] = TODAY () - 2 ) ) RETURN IF ( yesterdays_value - day_before_yesterday / day_before_yesterday > 0.2, "Text", BLANK () )
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
User | Count |
---|---|
101 | |
90 | |
80 | |
71 | |
70 |
User | Count |
---|---|
114 | |
99 | |
97 | |
73 | |
72 |