topic Re: Conditional filter in DAX Commands and Tips

Conditional filter

Anonymous — Mon, 13 Feb 2023 13:35:57 GMT

Hello, I need help I need to generate a filter that works as follows

Re: Conditional filter

ERD — Mon, 13 Feb 2023 16:05:09 GMT

Anonymous , so you have ONE date table and you want to use two similar slicers but affect visuals separately with them?

Re: Conditional filter

Anonymous — Mon, 13 Feb 2023 16:15:02 GMT

I need only 1 filter to manage two tables, the second table must show the values 7 days ahead of what is selected in the date filter

Re: Conditional filter

Anonymous — Mon, 13 Feb 2023 16:16:23 GMT

What I'm trying to display are measures, not columns

Re: Conditional filter

ERD — Mon, 13 Feb 2023 17:00:00 GMT

In that case you need to create another measure that will take into account this requirement. First one will show you the data in the chosen period, another one will show you the data 7 days ahead.

Re: Conditional filter

Anonymous — Mon, 13 Feb 2023 17:06:08 GMT

Can you help me with the syntax of that measure?

Re: Conditional filter

Anonymous — Mon, 13 Feb 2023 17:29:59 GMT

I already solved it thanks