Forum Discussion

ZachUnger's avatar
ZachUnger
Helper II
3 years ago
Solved

EXCEL to DAX Query

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

Need Help
Tips and Tricks
  • v-yanjiang-msft's avatar
    v-yanjiang-msft
    3 years ago

    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.

3 Replies

  • v-yanjiang-msft's avatar
    v-yanjiang-msft
    Community Support
    3 years ago

    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's avatar
      ZachUnger
      Helper II
      3 years ago

      Thank you, makes sense now 🙂 very much appreciated. 

      • v-yanjiang-msft's avatar
        v-yanjiang-msft
        Community Support
        3 years ago

        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