EXCEL to DAX Query

[ZachUnger]

Hi Team 

I'm struggling to convert the below from excel to DAX, hoping someone can help. 

1. =IF([@Date]="", "No Date Entered", IF([@Date]>DATE(2022,6,30),TEXT([@Date], "mmmmmmmmmm"), "Prior to FY 2022-23"))

2. =IF(ISNUMBER(SEARCH("Farm", [@[Detailed Description]])), "Farming","NA")

3. =IF(ISERROR([@[Detailed Description]]), "Error", "No")

Cheers 
Zach

[v-yanjiang-msft · Accepted solution]

Hi @ZachUnger ,

According to your description, here's my solution.

1.

Column =
IF (
    [@Date] = BLANK (),
    "No Date Entered",
    IF (
        [@Date] > DATE ( 2022, 6, 30 ),
        FORMAT ( [@Date], "MMMM" ),
        "Prior to FY 2022-23"
    )
)

 Result:

2.

Column =
IF ( CONTAINSSTRING ( [Detailed Description], "Farm" ), "Farming", "NA" )

Result:

3.Because after load table to Power BI Desktop, errors will become blank. If you want to distinguish error values, do it in Power Query, add a custom column.

let 
change=try [Detailed Description] otherwise "Error"
in
if change="Error" then "Error" else "No"

Result:

I attach my sample below for your reference.

Best Regards,
Community Support Team _ kalyj

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

[ZachUnger]

Thank you, makes sense now 🙂 very much appreciated. 

[v-yanjiang-msft]

Hi @ZachUnger ,

It's my pleasure! If you don't have other problems, would you mind accept the helpful replies as solutions? Then we are able to close the thread. More people who have the same requirment will find the solution quickly and benefit here, thank you!

Best Regards,
Community Support Team _ kalyj