How to give below condition in power BI

[Vani1987]

Hi Team,
developing qlik report to power Bi how to give below condition in power BI, can anyone help me on this

if(isnull(contractcreateddate) or contractcreateddate='NULL' or contractcreateddate='' or contractcreateddate='n/a','N/A',
'FY' & if(Month(DATE(contractcreateddate))>=9 and Month(DATE(contractcreateddate))<=12, right(Year(contractcreateddate)+1,2), right(Year(contractcreateddate),2))) as "Contract Start FY",

[Anonymous]

Hi @Vani1987 ，

To achieve the condition you mentioned in Power Query using M language, you can try the following:

if [contractcreateddate] = null or [contractcreateddate] = "NULL" or [contractcreateddate] = "" or [contractcreateddate] = "n/a" then "N/A" else "FY" & if Date.Month([contractcreateddate]) >= 9 and Date.Month([contractcreateddate]) <= 12 then Text.End(Text.From(Date.Year([contractcreateddate]) + 1), 2) else Text.End(Text.From(Date.Year([contractcreateddate])), 2)

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.           

[Vani1987]

the above logic is not working, here 2 if conditions are there also isnull taking as column in power BI, also  Month(DATE(contractcreateddate) 1st it has to extract month and then checking the condition, but in power BI if(Month taking as a column so throughing error, can any once help me to achive this

if(isnull(contractcreateddate) or contractcreateddate='NULL' or contractcreateddate='' or contractcreateddate='n/a','N/A', 'FY'

&

if(Month(DATE(contractcreateddate))>=9 and Month(DATE(contractcreateddate))<=12, right(Year(contractcreateddate)+1,2), right(Year(contractcreateddate),2))) as "Contract Start FY",

[PijushRoy]

Hi @Vani1987 

Please create sample pbix file with same column you have and share the google drive link here, give access to all

[PijushRoy]

Hi @Vani1987 

Create a custom column and try this syntax, please follow the pattern

= if [contractcreateddate]="null" OR [contractcreateddate]="null" OR [contractcreateddate]="null" OR 
[contractcreateddate]="n/a" then "N/A" else if (your second condition) then (your second output) else (final output)

Where you have column reference, please drag from Column available in right side window by double clicking.

If my comment helps you, please hit 👍

If solve your requirement, please mark as SOLUTION