Forum Discussion

gdssiqueira's avatar
gdssiqueira
Helper I
10 years ago
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    ...
Need Help
  • ankitpatira's avatar
    ankitpatira
    10 years ago

    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.

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

ckodadek's avatar
ckodadek
Helper I
10 years ago

I believe you could de-concatenate the timestamp/dates. Then use =MAX({timestampCells}:{timeStampCells}) to get the max value of the time stamp, by comparing the 5 versus the 4, or versus the other digits...
Also, you'd probably want some sort of column to store the max time stamp values of each date along with the corresponding values.
Seems like you could do this in excel then import it?