Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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 |
---|---|
88 | |
72 | |
69 | |
65 | |
57 |
User | Count |
---|---|
93 | |
93 | |
91 | |
76 | |
69 |