List.Max for three dates but did not include the max date if use that column as Date Slicer

[Volvo_Chang]

List.Max for three dates but did not include the max date if use that column as Date Slicer

How to include Max as >= not just > ?

[v-xuding-msft]

Hi @Volvo_Chang ,

Please share a few screenshots. Then we will understand clearly.

How to Get Your Question Answered Quickly

Best Regards,

Xue Ding

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

[Volvo_Chang]

Hello,

Sorry, the case is I have three start dates: MainitemStartDate, FreigtLinkStartDate, FreightItemStartDate, and three End Date: MainitemEndDate, FreigtLinkEndDate, FreightItemEndDate. 

I created a column called valid before: List.min( MainitemEndDate, FreigtLinkEndDate, FreightItemEndDate)

then change the data type to date and make it as a date between slicer.

When the select date include the exact end date. it will shows the data: for example, if the end date is 2/29, but the slicer select 2/28. the data will be gone. 

My question will be: how can I make it work if I select the date within the end date range but still shows the data: more detail in the attachment.

Thanks! 

[Volvo_Chang]

[amitchandak]

The information you have provided is not making the problem clear to me. Can you please explain with an example. If possible please share a sample pbix file after removing sensitive information.
Thanks.

My Recent Blog -
Time Intelligence - Direct Query