Transpose Currency Risk function

[ANM_97]

Hello!

How can I implement this function in DAX syntax?

iif (Currency= „RON”, „No”, case lower(RiskCoverage) when „no” then „Yes” when „Yes” then „No” end) as [Currency_Risk]

Column „RiskCoverage” contains this values: „Da” / „Nu”.

Thank you~

[Anonymous · Accepted solution]

Hi @ANM_97  create column as below

New column=IF(table[Currency]="RON","NO",if(table[riskCoverage]="Yes","NO","YES"))

Thanks & regards,
Pravin Wattamwar
www.linkedin.com/in/pravin-p-wattamwar

If I resolve your problem Mark it as a solution and give kudos.

[ANM_97]

It works!
Thank you very much! ~

[ANM_97]

Hi,

Thanks for the answers! 

Could I use a measure instead of a new column?

[amitchandak · Accepted solution]

@ANM_97 , Like this

New measure=IF(max(table[Currency])="RON","NO", switch( true(),lower(max(table[riskCoverage]))="yes","NO", lower(max(table[riskCoverage]))="no","YES"))

Row context will play a role

[amitchandak]

@ANM_97 

try like

Try as
New column=IF(table[Currency]="RON","NO", switch( true(),lower(table[riskCoverage])="yes","NO", lower(table[riskCoverage])="no","YES"))

[Anonymous · Accepted solution]

Hi @ANM_97  create column as below

New column=IF(table[Currency]="RON","NO",if(table[riskCoverage]="Yes","NO","YES"))

Thanks & regards,
Pravin Wattamwar
www.linkedin.com/in/pravin-p-wattamwar

If I resolve your problem Mark it as a solution and give kudos.