Forum Discussion
Khomotjo
1 year agoHelper II
Filter(ALL not working
Hello everyone, I have this measure : Picked_Orders = CALCULATE( DISTINCTCOUNT(StockMovements[Reference]), FILTER(ALL(StockMovements), TRUNC(StockMovements[Finalised_Date]) = TRUNC(MAX(Stoc...
Khomotjo
1 year agoHelper II
Hello Vanessa, I think I figured out what the issue is although I do not have the solution. I brought TRUNC(FinalisedDate) as a column and got this error :
vanessafvg
1 year agoCommunity Champion
what are you trying to do, convert the date to a date?