I am using an SQL table for my data source and I need to display the value on the latest date.
Referencing the screenshot below I need to display in a Card that the hours is 23 withour adding the value on 11/11/2019 (6).
Thank you for your help.
Go to Solution.
create a measure
var maxEffDate = calculate(max('Table'[Effective Date]);all('Table'))
then add this measure to your card visual
do not hesitate to give a kudo to useful posts and mark solutions as solution
View solution in original post
Take a look at the September 2023 Power BI update to learn more.
Join Microsoft Reactor and learn from developers.