Forum Discussion
Latest Row + Non-aggregate
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.
Hi,
I figured it out. Just added a date slicer and that gave me what I needed.
2 Replies
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
Hi,
I figured it out. Just added a date slicer and that gave me what I needed.
