Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hi all,
I need your help.
I am trying to calculate the mean of the most recent value for a specific time.
This is my situation:
I have reached the values for Tmax and TGmax according to the serial number (32, 65)
What I would like to have now is the same but with the times shown in red colour.
When I try to do that, the system takes the value as "count", so the final result that PBI shows is 3,00. It should be 5:00:00 aprox.
How can I do this?
Thank for your help!!!
Solved! Go to Solution.
Hi @Anonymous ,
You can try to use Convert() function to convert the data type to datetime and adjust the date format.
I have create a sample like this:
A_reach.y =
CONVERT (
SUMX (
FILTER (
ALL ( 'Table' ),
'Table'[Reach. y]
= CALCULATE ( MAX ( 'Table'[Reach. y] ), ALLEXCEPT ( 'Table', 'Table'[ID] ) )
),
[Reach. y]
)
/ DISTINCTCOUNT ( 'Table'[ID] ),
DATETIME
)
Attached the sample file in the below, hopes to help you.
Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous ,
You can try to use Convert() function to convert the data type to datetime and adjust the date format.
I have create a sample like this:
A_reach.y =
CONVERT (
SUMX (
FILTER (
ALL ( 'Table' ),
'Table'[Reach. y]
= CALCULATE ( MAX ( 'Table'[Reach. y] ), ALLEXCEPT ( 'Table', 'Table'[ID] ) )
),
[Reach. y]
)
/ DISTINCTCOUNT ( 'Table'[ID] ),
DATETIME
)
Attached the sample file in the below, hopes to help you.
Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@Anonymous , refer if this can help
User | Count |
---|---|
120 | |
65 | |
62 | |
56 | |
50 |
User | Count |
---|---|
177 | |
85 | |
70 | |
63 | |
55 |