Forum Discussion
How to select values from a database based on dates
Would something like this work?
In Power query convert the Last Change field to date type
(there are lots of onlien guides on how to that)
Create a table visual with Last changes, Projcet and Value
Create a slicer for Date
Hover the mouse under the elipses three dots ....
Click the V that appaers under the elipses and select After
Thanks for reaching out for help.
I have helped you, now please help me by giving kudos.
Remeber we are unpaid volunteers.
Click the thumbs up and accept as solution button.
One question per ticket please. If you need to extend your request then please raise a new ticket.
You will get a quicker response and each volunteer solver will get the kudos they deserve. Thank you !
That wont work - I need to be able to pull the last record changed before the data entered, not after. And if I just use a slicer, it will pull ALL the records prior to that date, not just the latest. For example, if I entered todays date, it would add up all three records in my sample and I only want it to add Project B and the latest entry of Project A