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.
Very new to DAX & expect this is quite simple
I have some currency columns in my data set that have base currency values & local currency
e.g
Haulage
Haulage_Base
TotalCost
TotalCost_base
etc
I want to create a Custom column that outputs either the local currency or base currency value based on an idSite in a related table
How I'd do this in SQL would be;
Case if othertable.idSite in (0,1,5) then haulage_base else haluage END as CustomHaulage
I've been successfully able to pull in the vaue of the idSite from the other table to a new custom column with
Site = RELATED(othertable[idSite])
So, I thought I could us CASE as below to create my new column
CustomHaulage = (Case when RELATED(othertable[idSite] in (0,1,5) then haulage_base else haulage END)
But I just get a column full of errors & "The syntax for 'Case' is incorrect. (DAX((Case when RELATED(AuctionsSage[idSIte] in (0,1,5) then haulage_base else haulage_auction END)))."
Solved! Go to Solution.
@donnellyk In DAX you use SWITCH statement instead of CASE
@donnellyk In DAX you use SWITCH statement instead of CASE
Thanks, got it working with a SWITCH
CustomHaulage = SWITCH(
TRUE (),
RELATED(OtherTable[idSIte])="0", thistable[haulage_base],
RELATED(OtherTable[idSIte])="1", thistable[haulage_base],
RELATED(OtherTable[idSIte])="5", thistable[haulage_base],
thistable[haulage_auction]
)
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 |
---|---|
51 | |
27 | |
24 | |
13 | |
8 |
User | Count |
---|---|
74 | |
56 | |
47 | |
16 | |
12 |