topic Re: Determine if 2 date columns are before today and before end of the next month in Power BI / DAX in DAX Commands and Tips

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

Anonymous — Thu, 24 Feb 2022 21:21:13 GMT

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

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

tackytechtom — Thu, 24 Feb 2022 21:36:28 GMT

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/

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

Anonymous — Fri, 25 Feb 2022 07:20:22 GMT

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)

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

tackytechtom — Sat, 26 Feb 2022 09:53:02 GMT

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/

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

Anonymous — Tue, 01 Mar 2022 05:38:16 GMT

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