Forum Discussion
Last Log Dashboard
Hello everyone,
I need to display in a Dashboard the last record that is in the column lectura_voltaje, as you can see in the meter only gives me the options of sum, average, etc, I just need to show the most recent record captured from the mysql database.
Hi Syndicate_Admin,
In that case you can filter your table to pick latest date.
Example:
Latest = CALCULATE([lectura_voltaje],FILTER('Table','Table'[Date]=MAX('Table'[Date])))Mark this post as a solution if that works for you!
3 Replies
Hi Syndicate_Admin,
Try using a measure that picks up the maximum value for your column, something like:
Latest = MAX('Table'[lectura_voltaje])Then use this measure in a card visual.
Works for you? Mark this post as a solution if it does!
What I need, is not that it collects the maximum value, but that the most recent value according to date.
Best regards.
Hi Syndicate_Admin,
In that case you can filter your table to pick latest date.
Example:
Latest = CALCULATE([lectura_voltaje],FILTER('Table','Table'[Date]=MAX('Table'[Date])))Mark this post as a solution if that works for you!
