Forum Discussion
Anonymous
7 years agoNot applicable
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!
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
Community Support
hi, Anonymous
You could try this way:
In Edit Queries, select "order create date" and “invoice date” then unpivot them.
Best Regards,
Lin