Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello everyone
I have a calculated measure for audience over time.
Solved! Go to Solution.
@fahadarshad You can use this approach, not sure if it fits your use case, I used some mock data.
1. Create a calculated table as follows:
@fahadarshad There is already an answered topic that seems to be what you are after:
https://community.powerbi.com/t5/Desktop/Obtain-the-maximum-value-of-a-Measure/m-p/856422
Thanks.
But there is also the requirement of wanting to know at what time the maximum value occured.
@fahadarshad Were you able to try my solution or did you use some other method? I'd be curious to know.
My solution for both max value of the measure and the time the max value occurs is here:
@fahadarshad You can use this approach, not sure if it fits your use case, I used some mock data.
1. Create a calculated table as follows:
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
95 | |
77 | |
68 | |
54 |
User | Count |
---|---|
144 | |
105 | |
102 | |
89 | |
63 |