Solved: Re: Filter on data

KatkaS · ‎09-18-2019

Hello,

I would need to measure in my excel when was the first and last approval on below data (there might be several approvals, but I'm only interested in first and last)...

The result should be if the first approval was after 4PM and if the last approval was after 4PM.

Does anyone would please know if such calculation would exist in Power BI?

Thank you very much!

v-chuncz-msft · ‎09-18-2019

@KatkaS

You may try MINX and MAXX.

https://community.powerbi.com/t5/Desktop/Take-max-of-date-by-column/td-p/611923

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

v-chuncz-msft · ‎09-18-2019

@KatkaS

You may try MINX and MAXX.

https://community.powerbi.com/t5/Desktop/Take-max-of-date-by-column/td-p/611923

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.