Forum Discussion
Solved
Plot latest data only
Hello, I'm new to PowerBI and DAX so I apologize if this is overly simple. I have a table with values and dates associated. Ex: Date Value 1/1 15 2/1 20 3/1 12 4/1 ...
gdssiqueira Here's the alternative to DAX,
In power bi desktop go to query editor, right click your table -> Duplicate.
For duplicated table click Group By as below.
This will give you date with latest time. Then click Merge Queries and merge it as below.
Expand new column to include Value column as below and Close & Apply. You will have two tables the second one will have data you want and every time you refresh both tables will be updated.
Create a measure:
MaxTimeStamp = CALCULATE(max('Date-Stamp'[Value]);FILTER('Date-Stamp';MAX('Date-Stamp'[TimeStamp])))
And use this for the chart