Determine if 2 date columns are before today and before end of the next month in Power BI / DAX

[Anonymous]

I have 2 columns that includes 2 different dates.

What i'm trying to do is to create a calculated column that determines whether column "governance" is <= TODAY and the "contract issue" column is <= the end of the next month (i.e. March). with either "yes" or "no" in the if statement.

Sample table below

Governance    Contract Issue

14/01/2022	04/03/2022
04/02/2022	11/03/2022

Much thanks in advance

[tackytechtom]

Hi @Anonymous ,

How about this:

IF (
    'Table2'[Govnernance] <= TODAY() && 
    'Table2'[Contract Issue] <= EOMONTH ( Today(),  1 ) &&
    'Table2'[Contract Issue] >  EOMONTH ( Today(), 0 ),
    "yes",
    "No"
) 

/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/

[tackytechtom]

Hi @Anonymous ,

How about this:

IF (
    'Table'[Governance] <= TODAY() && 'Table'[Contract Issue] <= EOMONTH ( Today(), 1 ),
    "yes",
    "No"
)

Does this solve your issue? 🙂

/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/

[Anonymous]

Hi @tackytechtom 

thank you for the quick response. i've tried it but it returns me all "contract issue" that's happened before the end of the next month (even in the past) what i was looking for was the contract issue dates between the start of next month and the end of next month (i.e. only all march dates only)

[Anonymous · Accepted solution]

Hi @Anonymous ,

You can create a calculated column as below to get it:

Flag = 
VAR _today =
    DATE ( 2022, 2, 25 )
RETURN
    IF (
        'Table'[Governance] <= _today
            && 'Table'[Contract Issue]
                >= EOMONTH ( _today, 0 ) + 1
            && 'Table'[Contract Issue] <= EOMONTH ( _today, 1 ),
        "yes",
        "no"
    )

Best Regards