Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Use different date filters based on a dropdown

Hi all,

We have a table containing “Price” and an “order create date” and “invoice date”.

I would like to filter for turnover (Price based on invoice date) and order intake (Price based on order create date).

I have a calender table.

So if I select “2019-03”, would it be possible to have a dropdown with values “turnover” and “order intake”? So if I select turnover, it filters for price based on invoice date, and if I select order intake, it filters based on order create date?

Thanks!

1 Reply

  • v-lili6-msft's avatar
    v-lili6-msft
    Icon for Community Support rankCommunity Support

    hi, Anonymous 

    You could try this way:

    In Edit Queries, select "order create date" and “invoice date” then unpivot them.

     

    Best Regards,

    Lin