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
I have 2 columns that i would like to subtract from one another after applied filters.
Eg.
Column B (with version type x and month number x) - Column A (with version type x and month number x)
What I currently have and is giving me wrong answer:
How do I go about writing this dax?
Hi @EMSSS22
Are version type and month number from the same table or different tables? What are the relationship between the tables? When you refer to "x" is it the same value used to filter both columns?
Hi
Yes its the same table.
and
Yes the same filter needs to be applied to both columns.
Thanks 🙂
Apologies for the late reply. Please try
ForecastCMVariance =
SUMX (
FILTER ( Commercial, Commercial[Version] = "x" && Commercial[month number] = y ),
Commercial[Forecast] - Commercial[Capital Rental]
)
Try something like
ForecastCMVariance =
CALCULATE (
SUMX (
FilteredCommercial,
FilteredCommercial[Forecast] - FilteredCommercial[Capital Rental]
),
FilteredCommercial[Version] = "x",
FilteredCommercial[month number] = y
)
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
70 | |
36 | |
21 | |
18 | |
15 |
User | Count |
---|---|
126 | |
30 | |
28 | |
24 | |
22 |