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.
@Anonymous It seems you have single quotes as part of your data itself in the SQL query but where as in DAX you are not considering that.
For Example - In SQL you are looking for 'Flat Fee Per Group' but in DAX you are looking for Flat Fee Per Group. Give a try including single quotes in your DAX search as well.
Proud to be a PBI Community Champion
Hi @Anonymous ,
Have you solved your problem?
If you have solved, please accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.
In addition, it seems that you're trying to achive if function in Power BI.
You could have a reference of the IF fomula below.
= IF('Table_Name'[Column_Name]= " " ,'Table_Name1'[Amount],0)
If you still need help, please share your dummy pbix which can reproduce your scenario so that we can help further on it.
Best Regards,
Cherry
Hi @Anonymous ,
Have you solved your problem?
If you have solved, please accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.
In addition, it seems that you're trying to achive if function in Power BI.
You could have a reference of the IF fomula below.
= IF('Table_Name'[Column_Name]= " " ,'Table_Name1'[Amount],0)
If you still need help, please share your dummy pbix which can reproduce your scenario so that we can help further on it.
Best Regards,
Cherry
@Anonymous It seems you have single quotes as part of your data itself in the SQL query but where as in DAX you are not considering that.
For Example - In SQL you are looking for 'Flat Fee Per Group' but in DAX you are looking for Flat Fee Per Group. Give a try including single quotes in your DAX search as well.
Proud to be a PBI Community Champion
User | Count |
---|---|
87 | |
84 | |
67 | |
62 | |
57 |
User | Count |
---|---|
138 | |
112 | |
94 | |
82 | |
71 |