Dynamic MAX date

igancedo — Thu, 07 Apr 2022 10:43:48 GMT

Hi everyone,

I need to limit the data that is being shown in a graph by following this criteria:

If today is before the 15th of the current month, show up to the last day of two months ago
If today is equal or after the 15th, show up to the last day of the previous month.

i.e: if we are one April 7th, show up to February 28th; after April 15th show up to March 31st and so on....

I think there are many ways to accomplish this, the aproach that I am trying to follow consists of a binary measure that determines the MAX date to show data depending on the current date. A few variables let me obtain dynamically the paramenters, however I am not sure how to proceed with the logic to determine the MAX date for each case.

VAR today_var = DATE(YEAR(TODAY()),MONTH(TODAY()),DAY(TODAY()))

VAR delay = DATE(YEAR(TODAY()),MONTH(TODAY()),15)

VAR maxDateBefore = EOMONTH(TODAY(), -2)

VAR maxDateAfter = EOMONTH(TODAY(), -1)

Perhaps that is not the best approach.

Any help is much appreciated, thanks in advance.

Regards

Re: Dynamic MAX date

tamerj1 — Thu, 07 Apr 2022 11:17:37 GMT

igancedo

You use

VAR EndOfLastMonth = EOMONTH ( TODAY (), -1 ) VAREndOfTwoMonthsAgo = EOMONTH ( TODAY (), -2 ) VArCriteriaDate = IF ( DAY ( TODAY () ) >= 15, EndOfLastMonth, EndOfTwoMonthsAgo )

topic Dynamic MAX date in DAX Commands and Tips

Dynamic MAX date

Re: Dynamic MAX date