Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |