topic Re: Return if one condition OR another is met in DAX Commands and Tips

Return if one condition OR another is met

lynnzrae — Mon, 01 Jul 2024 23:28:29 GMT

I am trying to create a column that returns if a project is "expired" or "not expired." (My column C)

If the permit start date is less than (before) to the construction start date OR if the construction start date is blank and the permit start date is less than (before/has passed) today it is expired.

Permit Start Date	Construction Start Date	New Column (Expired or Not Expired) What I am trying to create
6/24/2023		Expired
1/2/2022	12/30/2021	Not Expired
5/3/2024	5/15/2024	Expired

Re: Return if one condition OR another is met

Anonymous — Tue, 02 Jul 2024 01:32:31 GMT

Hi, lynnzrae

You can try the following measure to solve the problem.

Measure:

Condition = VAR _permitStart = SELECTEDVALUE ( 'Table'[Permit Start] ) VAR _dateConstruction = SELECTEDVALUE ( 'Table'[DateConstruction] ) VAR _today = TODAY () VAR _result = IF ( HASONEVALUE ( 'Table'[DateConstruction] ), IF ( ( _permitStart < _dateConstruction ) || ( ISBLANK ( _dateConstruction ) && _permitStart < _today ), "Expired", "Not Expired" ) ) RETURN _result

Best Regards,
Yang
Community Support Team

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly -- How to provide sample data in the Power BI Forum

Re: Return if one condition OR another is met

lynnzrae — Tue, 02 Jul 2024 10:42:54 GMT

I copy and pasted and it accepted the formula but it returned empty cells

I have my column with no errors but everything under the column header is blank

Re: Return if one condition OR another is met

Anonymous — Wed, 03 Jul 2024 02:19:35 GMT

Hi, lynnzrae

This DAX only works in Measure creation, if you want to achieve this effect in Calculate column you can use the following DAX.

DAX:

Condition column = IF ( [Permit Start] < [DateConstruction], "Expired", IF ( [DateConstruction] = BLANK () && [DateConstruction] < TODAY (), "Expired", "Not Expired" ) )

Best Regards,
Yang
Community Support Team

How to get your questions answered quickly -- How to provide sample data in the Power BI Forum

Re: Return if one condition OR another is met

lynnzrae — Wed, 03 Jul 2024 10:48:38 GMT

the above didn't return the correct values but I massaged the two formulas together and got what I needed so I am good to go. Thank you for your help!