Forum Discussion
Plot latest data only
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.
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.
Merging queries doesn't allow me to use any newly created columns, does it?
