topic Re: My column isn't returning a value has it should in DAX Commands and Tips

My column isn't returning a value has it should

lynnzrae — Tue, 27 Aug 2024 12:54:34 GMT

I have the following column command.

To my knowledge, the way it is written, if the criteria is not met (in the command), my return value should be not expired. Therefore in this column there should either be an "expired," or "not expired," value. However, as you can see I am getting blanks where it should state "not expired." How do I need to adjust my command to get the value "not expired" to return when the "expired" criteria is not met?

Permit Start Date Expiration =

IF(

( TPermitExpiration[Permit Construction Start Date] < TPermitExpiration[Construction Work Commenced Date])

|| (

ISBLANK ( TPermitExpiration[Construction Work Commenced Date] )

&& TPermitExpiration[Permit Construction Start Date] < TODAY()

"Expired",

"Not Expired"

)

Construction Work Commenced Date	Permit Start Date Expiration in 180 Days	Permit Start Date Expiration	Permit Construction End Date
	Nearing Expiration		11/1/2024
	Safe From Expiration	7/20/2028
	Safe From Expiration	4/19/2028
10/1/2022	Safe From Expiration	5/19/2027

Re: My column isn't returning a value has it should

Gabry — Tue, 27 Aug 2024 15:41:45 GMT

Hello lynnzrae ,

have you already tried like this?

IF(
OR(
TPermitExpiration[Permit Construction Start Date] < TPermitExpiration[Construction Work Commenced Date],
AND(
ISBLANK(TPermitExpiration[Construction Work Commenced Date]),
TPermitExpiration[Permit Construction Start Date] < TODAY()
)
),
"Expired",
"Not Expired"
)

Re: My column isn't returning a value has it should

lynnzrae — Tue, 27 Aug 2024 17:13:38 GMT

unfortunately it is still showing as blank. Although in either formulas it will filter as not expired

Re: My column isn't returning a value has it should

Anonymous — Wed, 28 Aug 2024 07:32:44 GMT

Hi, lynnzrae

Please refer to the screenshot.

Is this the output you expect?

Best Regards,

Community Support Team _Charlotte

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

Re: My column isn't returning a value has it should

lynnzrae — Wed, 28 Aug 2024 12:09:40 GMT

Yes it is. I got the text "Expired" but I do not get the text "Not Expired." I can't see how your formula is different than what I provided. What did you do differently to get the "Not Expired?"

Re: My column isn't returning a value has it should

Anonymous — Thu, 29 Aug 2024 02:31:58 GMT

Hi, lynnzrae

Please see the attachment. Hope it helps.

Column = IF( ( TPermitExpiration[Permit Start Date Expiration] < TPermitExpiration[Construction Work Commenced Date]) || ( ISBLANK ( TPermitExpiration[Construction Work Commenced Date] ) && TPermitExpiration[Permit Start Date Expiration] < TODAY() ), "Expired", "Not Expired" )

Best Regards,

Community Support Team _Charlotte

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

Re: My column isn't returning a value has it should

lynnzrae — Thu, 29 Aug 2024 10:29:38 GMT

The text still isn't showing. Could it be a setting somewhere?

Re: My column isn't returning a value has it should

lynnzrae — Thu, 29 Aug 2024 10:34:50 GMT

I realized it was a font setting but was there all along. Thanks for the help.