Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
I have data
In my donut chart i only want o show AMOUNT with latest Date .
I tried using top N but it works sometimes but dnt return anything most of time.
i tried using measure
Calculate (SUM(Amount),FILTER(table,currenttime>= max(currenttime)))
but none is working
Currenttime | AreaiD | Amount |
13/04/2022 10:14:00 AM | 1 | 10 |
13/04/2022 10:14:00 AM | 2 | 20 |
13/04/2022 09:14:00 AM | 1 | 10 |
13/04/2022 09:14:00 AM | 3 | 20 |
Solved! Go to Solution.
Earlier the date was passed as format 03/14/2000 mm/dd/yyyy hh:mm:ss
changed to
dd/mm/yyyy hh:mm:ss
and it is working,not sure why it was failing before
Hi,
Please show the expected result in a Table format.
@khush19 , Try a measure like
M1=
var _max = maxX(allselected(Table), Table[currenttime])
return
Calculate (SUM(Amount),FILTER(table,[currenttime]>= _max))
or
M1 =
var _max = datevalues(maxX(allselected(Table), Table[currenttime]))
return
Calculate (SUM(Amount),FILTER(table,datevalues([currenttime])>= _max))
Hi Amit,
Tried the measure but it didnt worked
Earlier the date was passed as format 03/14/2000 mm/dd/yyyy hh:mm:ss
changed to
dd/mm/yyyy hh:mm:ss
and it is working,not sure why it was failing before
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
81 | |
75 | |
60 | |
37 | |
33 |
User | Count |
---|---|
102 | |
56 | |
52 | |
46 | |
40 |