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

Power BI Monthly Update - June 2024

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

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors