EXCEL to DAX Query

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.