Tableau to power bi

[Anonymous]

I am currently working on migrating Tableau Reports to Power BI. I am currently facing problems in converting the Tableau Calculation to DAX in Power BI. Needed help in this.

Calculation = IF [Type]="Unb_SOF" and [CSD Fiscal Qtr]=[Current Fiscal Quarter +1] THEN [Asp Adjusted Amount]
ELSE FLOAT(0) END

Type

CSD Fiscal Qtr

Current Fiscal Quarter +1

Asp Adjusted Amount

Above data are direct columns in power bi

[Tanushree_Kapse]

Hi @Anonymous ,

Use the below measure:
Calculation= IF(AND(SELECTEDVALUE([Type])= "Unb_SOF"", SELECTEDVALUE([CSD Fiscal Qtr])=SELECTEDVALUE([Current Fiscal Quarter +1] )), [Asp Adjusted Amount], 0 )

I hope this helps!