Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
bikkalsharma
New Member

get minimum and maximum date from table

‎09-13-2022 05:43 PM

 

 

Hi, i am new to power BI. i want to get the minimum and maximum "Date & Time" for the selected property address, can anyone help me with this please?

 

Screenshot 2022-09-14 102848.png

Labels:
Message 1 of 3
292 Views
0
1 ACCEPTED SOLUTION
danextian
Super User
Super User

‎09-13-2022 05:58 PM

Hi @bikkalsharma ,

 

Try this as calculated columns:

Min DateTime =
CALCULATE ( MIN ( 'Table'[DateTime] ), ALLEXCEPT ( 'Table', 'Table'[Address] ) )

Max DateTime =
CALCULATE ( MAX ( 'Table'[DateTime] ), ALLEXCEPT ( 'Table', 'Table'[Address] ) )









Did I answer your question? Mark my post as a solution!


Proud to be a Super User!









"Tell me and I’ll forget; show me and I may remember; involve me and I’ll understand."
Need Power BI consultation, get in touch with me on LinkedIn or hire me on UpWork.
Learn with me on YouTube @DAXJutsu or follow my page on Facebook @DAXJutsuPBI.

View solution in original post

Message 2 of 3
283 Views
0
2 REPLIES 2
danextian
Super User
Super User

‎09-13-2022 05:58 PM

Hi @bikkalsharma ,

 

Try this as calculated columns:

Min DateTime =
CALCULATE ( MIN ( 'Table'[DateTime] ), ALLEXCEPT ( 'Table', 'Table'[Address] ) )

Max DateTime =
CALCULATE ( MAX ( 'Table'[DateTime] ), ALLEXCEPT ( 'Table', 'Table'[Address] ) )









Did I answer your question? Mark my post as a solution!


Proud to be a Super User!









"Tell me and I’ll forget; show me and I may remember; involve me and I’ll understand."
Need Power BI consultation, get in touch with me on LinkedIn or hire me on UpWork.
Learn with me on YouTube @DAXJutsu or follow my page on Facebook @DAXJutsuPBI.
Message 2 of 3
284 Views
0
bikkalsharma
New Member
In response to danextian

‎09-19-2022 04:40 PM

Hi danextian, Thank you very much mate,  it worked. Can you please describe this code for me please?

Message 3 of 3
218 Views
0

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Monthly Update - June 2024

Power BI Carousel June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

View All