Latest Row + Non-aggregate

[jakobd]

 I have a google forms that my warehouse manager fills out everyday to show how full the warehouses are. The google sheets is linked to Power BI no problem, but I need help getting the scorecards to display only the most recent row on the sheet and for the cards to show exactly what he input on the forms.

[v-piga-msft]

Hi @jakobd ,

What visual do you use for your scorecards in Power BI?

If you want to show the latest data in scorecards, you may creata a measure with Top N.

In addtion, I have a little confused about "show exactly what he input on the forms."

If it is convenient, could you share some screanshots and describe your scenario in more details.

Reference:

Show only data from the latest date

Best  Regards,

Cherry

[jakobd · Accepted solution]

Hi,

I figured it out. Just added a date slicer and that gave me what I needed.