Use different date filters based on a dropdown

[Anonymous]

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!

[v-lili6-msft]

hi, @Anonymous 

You could try this way:

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

Best Regards,

Lin