Forum Discussion

HichamGRC's avatar
HichamGRC
Frequent Visitor
3 years ago

Filter measures with a filter date between

Hi,

I have a table which displays measures by User. 

Example : 

- User | NB created contacts | NB created opportunities | NB created appointments

 

The client wants to filter by date of creation. Each entity (contact, opportunity, appointment) have a createdon field.

I don't know if it's possible to add a date filter and filter on all the measures when the user choose the between dates.

Until now, I used a slicer and made the field "beteen two dates" but in my scenario, I need one field date than can filter on all my measures.

Thanks,

Need Help

2 Replies

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    3 years ago

    That seems like standard functionality. What have you tried and where are you stuck?

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Icon for Super User rankSuper User
    3 years ago

    Hi,

    The data will have to be transformed (specifically Unpivoted) to create one Date column from the 3 Date columns.  To get further help, share some data and show the expected result.