Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi Experts
How would you subtract the following...
A1 France-Benelux VPY%1 = Var FB = CALCULATE([NSvPY1% (Reported PY)], FILTER( 'Reporting Hierarchy 2','Reporting Hierarchy 2'[Tweaked Franchise]="INFUSION DEVICES"), FILTER( 'Reporting Hierarchy 2','Reporting Hierarchy 2'[Tweaked Sub Region] IN {"French Region","BENELUX Region"})) VAR FBN = CALCULATE([NSvPY1% (Reported PY)], FILTER(Management,Management[Level5] IN {"French Region","BENELUX Region"})) Return
Solved! Go to Solution.
Hi @Anonymous,
What do you mean by subtracting two variables? If they are numeric, just one minus another like this FB - FBN. Can you share a dummy sample and some snapshots to make it clear, please?
Best Regards,
Hi @Anonymous,
What do you mean by subtracting two variables? If they are numeric, just one minus another like this FB - FBN. Can you share a dummy sample and some snapshots to make it clear, please?
Best Regards,
Hi thanks for the feedback managed to resolve the issue
VAR 1
VAR 2
VAR 3 = VAR 1- VAR2
Return
VAR 3
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
115 | |
100 | |
88 | |
69 | |
61 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |