How to give below condition in power BI

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

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",

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.