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.
Hi guys I need your assistance/tips in orders to present (with direct query connection) latest battery value.
for eample here's my sample data:
CellDateTime | Battery |
7/20/2018 3:53 | 97 |
7/25/2018 13:32 | 100 |
7/25/2018 13:33 | 100 |
I would like to create a measure that calculates the latest battery state (7/25/2018 13:33) 100.
TNX !.
Hi @Noak,
Based on my test, you can refer to below steps:
1.I have entered some sample data in SQL Serve like the picture below and use the Power BI to get the data in Direct Query mode.
2.Create a measure.
Measure 2 = IF(CALCULATE(SUM(Table_4[CellDateTime]))=MAXX(ALL('Table_4'),'Table_4'[CellDateTime]),CALCULATE(SUM(Table_4[Battery])),BLANK())
3.Create a Table visual and add the field. Now you can see the result.
Regards,
Daniel He
Hi @Noak,
If you want to show in the card, you could use this measure:
Measure = CALCULATE(SUM(Table_4[Battery]),FILTER('Table_4','Table_4'[CellDateTime]=MAX('Table_4'[CellDateTime])))
Regards,
Daniel He
Hi @Noak,
It could work on my side:
From your description that you could not ues the filter function, could you please check the "Allow unrestricted measures in DirectQuery mode" has been checked? And you could test the measure again.
Regards,
Daniel He
Thank you @v-danhe-msft
Its works now, but it gives me the wrong output . Any ideas why it might happen?.Max(Nano[CellDateTime]) => 8/2/2018 10:58:44 AM
CALCULATE(sum(Nano[Module44Bat]),FILTER(nano,Nano[CellDateTime]=Max(Nano[CellDateTime])) => 0
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 |
---|---|
114 | |
99 | |
75 | |
73 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |