Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Headcount filtered by date

Hi,

 

I'm buidling a dashboard and getting the data from an incremental data base. the logic of what i want to do is I want to select a day from a date slicer, and i want to filter the [LastInserted] to match the date from the slicer.

 

the way the data base is set up is that daily they dump a copy of the current info of all employees, and they date stamp.

 

i have tried to use the countrows function to pair it with the date slicer but i haven't had any luck. Any thoughts?

Need Help

2 Replies

  • nickyvv's avatar
    nickyvv
    Most Valuable Professional
    6 years ago

    Can you create a measure where you filter on the date. Something like LastInserted = SELECTEDVALUE(Date)

    P.S. This is the Service Forum, you might have more luck in the Desktop or DAX Commands and Tips Forum.

     

    Did I answer your question? Then please mark my post as a solution!
    My blog: nickyvv.com

  • v-diye-msft's avatar
    v-diye-msft
    Community Support
    6 years ago

    Hi Anonymous 

     

    you might consider creating pbix file that will contain some sample data, upload the pbix to onedrive or dropbox and share the link to the file. Please do not forget to describe the expected results based on this sample data.