From the timestamp only the first date

[Wokster]

Hi,

At this moment im stuck i one of my power bi reports.

I want to do the following, in my dataset a incidentnumber has multiple timestamps. I tried some measures but still i cannot get only the first date as shown in the picture below. Is there someone who can help me with this problem?

Kind regards,

Kay Wokke

[v-cgao-msft · Accepted solution]

Hi @Wokster ,

Please try:

Measure = CALCULATE(MIN('Table'[TimeStamp]),ALLEXCEPT('Table','Table'[incidentNumber]))

Column = CALCULATE(MIN('Table'[TimeStamp]),FILTER(ALL('Table'),'Table'[incidentNumber]=EARLIER('Table'[incidentNumber])))

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

[Wokster]

Hi Gao,

The problem is is that incidentnumber is not in the same table as the timestamp.. so the column one is not working also the measure one is not working.

But what you show me as column is exactly what i need!

[Wokster]

Does anyone has a solution for this? 

[Wokster]

I did something wrong above it is working verry well! 

Thanks for it.

[AlB]

Hi @Wokster 

1. Place incidentNumber in a table visual

2. Create this measure and place it in the table visual

Measure_ =
MIN ( Table1[timeStamp] )

Note this will provide date and time. You talk about getting the date, so if it's only the date that you are after (excluding the time):

Measure2_ =
DATEVALUE( MIN ( Table1[timeStamp] ) )

Please accept the solution when done and consider giving a thumbs up if posts are helpful.  Contact me privately for support with any larger-scale BI needs, tutoring, etc.

[Greg_Deckler]

@Wokster Measure = MIN('Table'[timeStamp]) 

?