Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
hide
Frequent Visitor

I want to display the maximum date side by side for the dates in the table

Hello,

Sorry for the elementary question.

I want to display the maximum date side by side for the dates in the table.

I want the maximum over all rows, not the maximum per row.

 

max(date) = max('Data'[Date])

sample1.png

What I would like is:

sample2.png

1 ACCEPTED SOLUTION
john_elmasry
Frequent Visitor

You Can use "ALL" Function

 

Maximum Date = CALCULATE(max('Data'[Date]),ALL('Data'))

View solution in original post

3 REPLIES 3
hide
Frequent Visitor

Thank you! It is solved. it was very helpful.

john_elmasry
Frequent Visitor

You Can use "ALL" Function

 

Maximum Date = CALCULATE(max('Data'[Date]),ALL('Data'))

When applying a filter to the table, how can I apply a filter to "min(date)" as well?

 

min(date) = CALCULATE(MIN('Data'[date]),ALL('Data'))

sample3.png

Click on another list to filter this table. How can I make it so that min(date) is also filtered?

I want to make it the minimum date after filtering.

Below is an image of what I want to do.

sample4.png

 

This kind of processing is easy with Tableau, but PowerBI is difficult.

Helpful resources

Announcements
Fabcon_Europe_Social_Bogo

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 Carousel June 2024

Power BI Monthly Update - 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.