cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
jakobd Frequent Visitor
Frequent Visitor

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.

1 ACCEPTED SOLUTION

Accepted Solutions
jakobd Frequent Visitor
Frequent Visitor

Re: Latest Row + Non-aggregate

Hi,

 

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

2 REPLIES 2
Community Support Team
Community Support Team

Re: Latest Row + Non-aggregate

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

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
jakobd Frequent Visitor
Frequent Visitor

Re: Latest Row + Non-aggregate

Hi,

 

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