Forum Discussion
if else statement in dax function
Hello All, I have a tableau dashboard where I have parameter having values like US and Canada,APAC and Overall. And I have department values like Central,Georgia,Hyd and Pune My requirement ...
Anonymous , You do not need a table you need a column. If you have that table join with this column
Switch( True() ,
[Department] in {"Central","Georgia"} , "US and Canada",
[Department] in {"Hyd","Pune"} , "APAC",
"Other"
)
If this does work, Please share the final outcome on tableau
Hi amitchandak ,
Below is what I am expecting .
In the DAX you mentioned above you are not using the table I created inside power BI for regions.