Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hello All,
I am creating a custom column and I am not getting any syntax errors but when I click ok I am getting below error.
Could any one please help how to fix this
Solved! Go to Solution.
Hi,
Switch is a DAX function not an M function? Write it as a calculated column formula
=if(and([Region="APAC",OR([AgentDepartment]="Hyd",[AgentDepartment]="Unknown")),"ASD Hyd",blank())
Hope this helps.
Hi,
Switch is a DAX function not an M function? Write it as a calculated column formula
=if(and([Region="APAC",OR([AgentDepartment]="Hyd",[AgentDepartment]="Unknown")),"ASD Hyd",blank())
Hope this helps.
Write a calculated column formula in DAX not a Custom formula in M
Hi @Ashish_Mathur ,
Could you please help how to do dax for this.
Here my region is a table created in power bi
Already shared that.
User | Count |
---|---|
131 | |
74 | |
70 | |
58 | |
53 |
User | Count |
---|---|
190 | |
97 | |
67 | |
62 | |
54 |