Forum Discussion

Help_me's avatar
Help_me
Frequent Visitor
5 months ago
Solved

How to write this IF statement for same date, but different statuses?

Hello, I have the two columns below in the same table. "Cookie Type" is text field and "Baked_Date" is a date value. How can I write the IF statement in DAX for the concept: If the same baked_date ...
"DAX "
"if statement"
  • Kedar_Pande's avatar
    Kedar_Pande
    5 months ago

    Help_me 

     

    Calculated column:

    Eat Flag = 
    VAR CurrentDate = 'Table'[Baked_Date]
    RETURN
    IF(
    CALCULATE(
    COUNTROWS('Table'),
    'Table'[Baked_Date] = CurrentDate,
    'Table'[Cookie Type] IN {"Chewy", "Chunky"}
    ) = 2,
    "Eat",
    "Do not eat"
    )

    Checks if both Chewy + Chunky exist on same Baked_Date.

v-achippa's avatar
v-achippa
Community Support
5 months ago

Hi Help_me,

 

Thank you for reaching out to Microsoft Fabric Community.

 

Thank you lbendlin, FBergamaschi and Kedar_Pande for the prompt response.

 

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided by the user's for the issue worked? or let us know if you need any further assistance.

 

Thanks and regards,

Anjan Kumar Chippa

  • v-achippa's avatar
    v-achippa
    Community Support
    4 months ago

    Hi @Help_me,

     

    We wanted to kindly follow up to check if the solution provided by the user's for the issue worked? or let us know if you need any further assistance.

     

    Thanks and regards,

    Anjan Kumar Chippa