Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I have a column list of dates, how do I get the minimum date SELECTED date while ignoring one specific value?
For example: I want to get the value of 23/03/17 from the selected values ignoring 00/01/01.
Thanks in advance!
Solved! Go to Solution.
Hi @lpd82
please try
=
MAXX ( TOPN ( 2, ALLSELECTED ( 'Table'[Date] ), 'Table'[Date] ), 'Table'[Date] )
Hi @lpd82
please try
=
MAXX ( TOPN ( 2, ALLSELECTED ( 'Table'[Date] ), 'Table'[Date] ), 'Table'[Date] )
User | Count |
---|---|
47 | |
26 | |
22 | |
17 | |
15 |
User | Count |
---|---|
53 | |
34 | |
17 | |
17 | |
15 |