Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello
could someone help me please
i try to show the last process in a year in a table
which is filtered on a customer
THANKS
Solved! Go to Solution.
hi @Hikmet_JCI ,
Try this
_Measure = IF ( Customer[Date] = CALCULATE ( MAX ( Customer[Date] ), ALLEXCEPT ( Customer, Customer[Bez] ) ),Customer[Date] )
Thanks!
hi @Hikmet_JCI ,
Try this
_Measure = IF ( Customer[Date] = CALCULATE ( MAX ( Customer[Date] ), ALLEXCEPT ( Customer, Customer[Bez] ) ),Customer[Date] )
Thanks!
hi @Hikmet_JCI
Did you try this
_Measure = IF ( MAX(Customer[Date]) = CALCULATE ( MAX ( Customer[Date] ), ALLEXCEPT ( Customer, Customer[Bez],Customer[KD] ) ),MAX(Customer[Date]) )
you can try to create a column
Column =
VAR _max=CALCULATE(MAX('Table'[Date]),ALLEXCEPT('Table','Table'[Art]))
RETURN if(_max='Table'[Date],'Table'[Date],blank())
Proud to be a Super User!
Hi.
but when I use a filter it doesn't show me correctly
I would have to consider one more column
then you just need to create a measure
Measure = max('Table'[Date])
please see the attachment below
Proud to be a Super User!
User | Count |
---|---|
128 | |
108 | |
100 | |
64 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |