Forum Discussion

Khomotjo's avatar
Khomotjo
Icon for Helper II rankHelper II
1 year ago
Solved

Format Date returned in a meaure

I have the following measure : 

Total_ Picked = CALCULATE(
COUNTROWS(StockMovements),
FILTER(ALL(StockMovements), StockMovements[Finalised_Date]=MAX(StockMovements[Required_Date])

))      
The issue is MAX(StockMovements[Required_Date]) returns a date/time . I only want the date. I tried using FORMATwith "yyyy,mm,dd" but this changed the date into a text.  The original Required_Date is a date/time but I changed  into short date. 
Need Help
  • bhanu_gautam's avatar
    bhanu_gautam
    1 year ago

    Khomotjo , Try using 

     

    DAX
    Total_Picked = CALCULATE(
    COUNTROWS(StockMovements),
    FILTER(
    ALL(StockMovements),
    TRUNC(StockMovements[Finalised_Date]) = TRUNC(MAX(StockMovements[Required_Date]))
    )
    )

1 Reply

  • bhanu_gautam's avatar
    bhanu_gautam
    Icon for Super User rankSuper User
    1 year ago

    Khomotjo , Try using 

     

    DAX
    Total_Picked = CALCULATE(
    COUNTROWS(StockMovements),
    FILTER(
    ALL(StockMovements),
    TRUNC(StockMovements[Finalised_Date]) = TRUNC(MAX(StockMovements[Required_Date]))
    )
    )