End of Date function not showing the correct max date?

[Anonymous]

Hi all,

I've created a new column in query editor that uses the End of Month function and it has generated the dates which range from 31.01.2017 - 31.03.2020.

I'm trying to use the Max date on a card from this column however it keeps showing the max date as 31.12.2019 and the first date as 28.02.2019. Why is it not showing the first date as 31.01.2017 and last date as 31.03.2020? I've checked and there's no filters etc applied, the whole data set is there.

Thanks in advance!

Saj

[ryan_mayu]

@Anonymous 

Could you please share the screenshot of your measure and data?

[Tahreem24]

@Anonymous ,

Show some screen shot of that cards. And also what DAX you are using for Max and MIn date on Card visuals.

Also meanwhile try the below:

For Showing MIN Date = Take date column on card and select Earliest option (As per below Screen shot)

FOr Showing MAX Date = Take date column on card and select Latest option

[Anonymous]

I can't share a screenshot.

I have tried using the earliest and latest and it didn't work either. I'm using MAX('Sheet1'[Date]) in my formula.

[amitchandak]

@Anonymous , There can be filter at page level. Check that.

If you put it on card then it should show min with min and First

and Max with Max and Last

[Anonymous]

I mentioned in the original post that I've checked all filters, nothing is being applied, which is why I can't workout why the max and min wouldn't be working.

[ryan_mayu]

@Anonymous 

Maybe you can try this.

create a new table

datetime = CALENDAR(date(2017,1,31),date(2020,3,31))

create min and maxdate

maxdate = max('datetime'[Date])

mindate = min('datetime'[Date])

 

[Anonymous]

It needs to be dynamic using the dates in the dataset