Calculate the Second To Last Date But Remove The Timestamp? (CALCULATE & FORMAT?) - CARD

[Pete_81]

I have this:

CalcLastWeek =
VAR GetDate =
CALCULATE( MAXX ('MyTable','MyTable'[Report Date]), ALLSELECTED('MyTable') )
RETURN
CALCULATE(
MAXX('MyTable','MyTable'[Report Date]),
FILTER(ALL('MyTable'),'MyTable'[Report Date]< GetDate)
)

Which does the job, but I need to remove the timestamp that is also displayed on the card.

I can't seem to find the correct place to put the FORMAT code.

Any help would be greatly appreciated. Thanks.

[Samarth_18 · Accepted solution]

Hi @Pete_81 ,

You can update your measure like below if you want to handle formatting in measure itself:-

CalcLastWeek =
VAR GetDate =
    CALCULATE (
        MAXX ( 'MyTable', 'MyTable'[Report Date] ),
        ALLSELECTED ( 'MyTable' )
    )
VAR result =
    CALCULATE (
        MAXX ( 'MyTable', 'MyTable'[Report Date] ),
        FILTER ( ALL ( 'MyTable' ), 'MyTable'[Report Date] < GetDate )
    )
RETURN
    FORMAT ( result, "MM/DD/YYYY" )

or you can change it explicitly from the top ribbon :

Thanks,

Samarth

[Tanushree_Kapse]

Hi @Pete_81 ,

You can simply click on the measure, in the ribbon on top, you would see a format and data type option: you can set the data type from Date-time to just date. Anf also can set the format from there.

Or else try this measure:

Measure= Format (Calclastweek, "dd/mm/yyyy")

Mark this as a solution if I answered your question. Kudos are always appreciated.

Thanks