Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.
Check it out now!Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more
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])
What I would like is:
Solved! Go to Solution.
You Can use "ALL" Function
Maximum Date = CALCULATE(max('Data'[Date]),ALL('Data'))
Thank you! It is solved. it was very helpful.
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'))
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.
This kind of processing is easy with Tableau, but PowerBI is difficult.