Return Earliest Timestamp Based on Filter Selection

[zeke1970]

Hello,

I have been reseraching but cannot find the result I am looking for.   I want PowerBI to return the earliest timestamp based on Date slicer and customer slicer.

For example, if user selects Date 5/31/2025 and Customer A, I want PowerBI to return in table form:

Customer     Item                Purchase Date

A                  mushroom        5/31/2025 11:13:09 AM

Any assistance is appreciated!

 https://drive.google.com/file/d/1VbLxk4i6IOCc9-0a4vel-y3Q0KEcPP8P/view?usp=drive_link 

[Ashish_Excel · Accepted solution]

Hi,

Download PBI file from here.

Hope this helps.

[speedramps]

@zeke1970 

Thaks for accept 2 solution.
Please can you also accept mine.

It was one of the first and all the solutions work.

The points help reflect my competency and your gratitude.

Thank you for your assistance in the matter

[v-ssriganesh]

Hello @zeke1970,

Could you please confirm if your query have been resolved? If they have, kindly mark the helpful response and accept it as the solution. This will assist other community members in resolving similar issues more efficiently.

Thank you.

[v-ssriganesh]

Hi @zeke1970,
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank you.

[v-ssriganesh · Accepted solution]

Hi @zeke1970,
Thank you for reaching out to the Microsoft fabric community forum.

I’ve reproduced your use case and confirmed that I’m getting the expected output based on your requirements:

• Earliest timestamp record displayed as per slicer selection.
• Only the single row with the earliest timestamp appears.

Output:

For your reference, I’m attaching the .pbix file with the implemented solution.

Thank you, @Ashish_Excel & @speedramps for sharing your valuable insights.

If this information is helpful, please “Accept as solution” and give a "kudos" to assist other community members in resolving similar issues more efficiently.
Thank you.

[v-ssriganesh]

Hi @zeke1970,
I hope this information is helpful. Please let me know if you have any further questions or if you'd like to discuss this further. If this answers your question, please accept it as a solution and give it a 'Kudos' so other community members with similar problems can find a solution faster.
Thank you.

[Ashish_Excel · Accepted solution]

Hi,

Download PBI file from here.

Hope this helps.

[speedramps]

The Date field has a Date/Time data type with short date formating.

It is important that you learn the difference between a data/type and formating

Changing the format just changes how the data will be displayed.

It wil not change the underlying value of the data in the releationship !

If you remove the short date formating then you can clsee the problem with the relationship

For example 28/05/2025 00:00:00 will not relate to 28/05/2025 14:20:00 because they are differt values !!!

Delete the relationship and delete the Date table (you dont need it)

Just add a new date column  (with a date type) on Table1 based  on Purchase Date

Then use that date in your slicer.

Then display the min Purchase Date (with time) for the sliced date.

Please click thumbs up and the [accept solution] button

[zeke1970]

https://drive.google.com/file/d/1VbLxk4i6IOCc9-0a4vel-y3Q0KEcPP8P/view?usp=sharing 

[zeke1970]

https://app.powerbi.com/links/6oDG4_bo9A?ctid=b33c5210-cf78-4b55-99d2-40563e2b54eb&pbi_source=linkSh... 

[speedramps]

Please give access to your data, so helpers can hep you