Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

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

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.

Date
Format
time
Timestamp
  • Samarth_18's avatar
    Samarth_18
    5 years ago

    Hi Anonymous ,

     

    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

2 Replies

  • Tanushree_Kapse's avatar
    Tanushree_Kapse
    Icon for Impactful Individual rankImpactful Individual
    5 years ago

    Hi Anonymous ,

    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

     

     

  • Samarth_18's avatar
    Samarth_18
    Icon for Community Champion rankCommunity Champion
    5 years ago

    Hi Anonymous ,

     

    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