Qlik to PBI migration

[Bharathi09]

Hello All,

I Have below qlik logic which I need to show in Power BI custom Column

if(len([Alternate  Flag])=0 and len([Alternate SD Flag])=0,'N',
if(len([Alternate  Flag])=0 and [Alternate  SD Flag]='Y','Y-USA',
[Alternate  Flag]) as Flag_Check

I have only record 'Y' in both Alternate Flag and Alternate SD Flag that is 'Y'

but in output it's showing all three value N, Y, Y-USA in Qlik

How it could be possible?

and please help me in converting this to PBI

Thanks!

[TauseefKhan · Accepted solution]

Hi @Bharathi09,

Check with this:

Flag_Check =
IF(
LEN([Alternate Flag]) = 0 && LEN([Alternate SD Flag]) = 0,
"N",
IF(
LEN([Alternate Flag]) = 0 && [Alternate SD Flag] = "Y",
"Y-USA",
[Alternate Flag]
)
)

******** Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.********