Forum Discussion
Custom if statement
Hello! I am trying to write a switch statement (or an if statement), but it's not working correctly. I want to create an equation/statement that takes the number for the minimum no of tms (the...
Hey nataliesmiy1357 ,
the link you provided is not the link to pbix file, but instead it points to the report in your power bi tenant. As I'm not a member of your tenant, I can't access the report.
Regards,
Tom
No, I can't access your tenant.
It looks like my company won't share..... so let's try another way.... how can I create an if statement with two things, then...
if (a and b) then ___
Hey nataliesmiy1357 ,
using Power Query (M) here is a M snippet
if [Dim1] = "A" and [Dim2] = "B" then "this" else "that"and the same using DAX to create a calculated column
if ( ( 'Table'[Dim1] = "A" && 'Table'[Dim2] = "B" ), "this" , "that" )If this does not help consider creating a pbix using Power BI Desktop and uploading the file to your private onedrive or dropbox account (this is how most of us share files).
Regards,
Tom