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.
I'm relatively new to PowerBI and DAX statements and I'm having an issue with writing an IF statement with multiple conditions.
I need to use the Volume if it is current year, type is Actuals and company is ITA.
These are the DAX statements I have tried:
_CurrentYearITA = IF(AND('AMER DBP Retail Bookings'[DTF_Current_ITA_YTD] = "Y",'AMER DBP Retail Bookings'[PL_PlanCode] = "ACTUALS",'AMER DBP Retail Bookings'[CO_Company] = "ITA"),'AMER DBP Retail Bookings'[_Volume],0)
This statement says too many arguments for the AND function
and
_CurrentYearITA = IF('AMER DBP Retail Bookings'[DTF_Current_ITA_YTD] = "Y"||'AMER DBP Retail Bookings'[PL_PlanCode] = "ACTUALS"||'AMER DBP Retail Bookings'[CO_Company] = "ITA";'AMER DBP Retail Bookings'[_Volume];0)
This statement says incorrect syntax starting at the semi-colon after "ITA"
Solved! Go to Solution.
AND function can take only 2 parameters.
Check the documentation.
You will need to chain the AND operator && to achieve what you want.
e.g.
The AND function only lets you compare 2 things. However you can nest further AND statements. This can be something like
_CurrentYearITA = IF( AND( 'AMER DBP Retail Bookings'[DTF_Current_ITA_YTD] = "Y", AND( 'AMER DBP Retail Bookings'[PL_PlanCode] = "ACTUALS", 'AMER DBP Retail Bookings'[CO_Company] = "ITA" ) ), 'AMER DBP Retail Bookings'[_Volume], 0 )
From a best practice perspective, the SWITCH statement is the way to go.
AND function can take only 2 parameters.
Check the documentation.
You will need to chain the AND operator && to achieve what you want.
e.g.
anandav,
Thanks for the info. It seems to be working now. I'm not familiar with DAX syntax having just started using it and your response was helpful. I appreciate it.
If it solved your problem could you please mark it as the solution?
SWITCH ( TRUE (), Product[Size] = "XL" && Product[Color] = "Red", "Red and XL", Product[Size] = "XL" && Product[Color] = "Blue", "Blue and XL", Product[Size] = "L" && Product[Color] = "Green", "Green and L" )
Didn't know about using the True() function in SWITCH. Read up on it after I saw your post. Cool!
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 |
---|---|
112 | |
100 | |
77 | |
74 | |
49 |
User | Count |
---|---|
146 | |
108 | |
106 | |
90 | |
62 |