Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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.
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
110 | |
109 | |
108 | |
93 | |
61 |
User | Count |
---|---|
171 | |
139 | |
133 | |
102 | |
86 |