Need to create First Date measure for selected period range that does not change by month.

[evgenynartakhov]

Hello,

I need to create a measure that shows "real" first selected date in the table with periods (month-year).

For example: My selected date range is May 2020 to Dec 2020. If I have M-Y in columns, first selected date will change for each period: for May-2020 it is May 1, for Jun-2020 it is June 1, ..., for Dec-2020 it is Dec 1. I need the first date to show Jan 1 in all periodic columns:

How do I do that?...

Thank you in advance!

Evgeny

[V-lianl-msft · Accepted solution]

Hi @evgenynartakhov ,

Please try measure like below:

Measure = 
VAR MIN_DATE =  CALCULATE(MIN('Table'[Date]),ALLSELECTED('Table'))
VAR MONTH_DATE = CALCULATE(MIN('Table'[Date]),ALLSELECTED('Table'[Date]))
RETURN IF(MIN('Table'[Date])=MIN_DATE,DATE(YEAR(MIN_DATE),1,1),MONTH_DATE)

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

[Fowmy]

@evgenynartakhov 

Hope you have a dates table, create the following measure and add it:

1st Date =  STARTOFYEAR(Dates[Date])

[evgenynartakhov]

Thank you for the reply.

This gives me the first date in the calendar table, but not the first selected date... Date selections may also have multiple years, which complicates things more.

Regards,

Evgeny

[Fowmy]

@evgenynartakhov 
I did not understand that any how can you try this measure?

CALCULATE (
    MIN ( dates[Date]).
    REMOVEFILTERS (dates)
)

[evgenynartakhov]

Still getting the period first dates instead of just May 1, 2020 in all periodic clumns...

Regards,

E