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
Would something like this work?
I think that works, thanks for the quick response. One more question. I actually have one more variable on my projects table on whether the project update is approved or not. I would like to exclude project updates that are not approved. For example if my data included approval and I selected today as a date, it would not use the Jun 22 update for Project A since it was not approved. Can I add a condition of Approved = "Y" into the measure you created
Project Name Value Last change Approved Project A 1000 1-Mar-22 Y Project A 1500 1-Jun-22 N Project B 500 1-Jan-22 Y