Forum Discussion
Helper IFilter two columns with one slicer
Hello,
I've created a dashboard that shows business KPI updated on a daily basis and with historical data.
Below is a simplified example of the dataset showing the orders. Each order has an order date and a requested delivery date.
Example data:
The Dashboard hasa slicer for the date, where "Yesterday" is pre-selected, but the user can go back into the past.
The data table is connected to calendar via "order date". The calender itself is connected to the date slicer in the dashboard.
This is the measure I currently have and it shows the Order Entry MTD for the selected month:
Order Entry_MTD = TotalMTD(SUM('Append1'[Turnover]),'Calendar'[Date])
I need to show Order Entry MTD for the selected month, but only for orders with requested delivery date within the selected month. How can I do that? It's not possible to connect the calendar also to "Requested Delivery Date". A second calendar for the requested delivery date would be possible, but that's not covenient for the user.
Can you guys help me?
3 Replies
- amitchandak
Super User
bendejnp , you can use inactive relation and userelationship
example
calculate( calculate( SUM(Sales[Sales Amount]),USERELATIONSHIP ('Sales'[CreateDate], 'Date'[Date])),DATESMTD('Date'[Date]))
Refer
bendejnpHello amitchandak ,
it works, but now the formula shows all Orders with create date within the selected month. But it also shows orders where the requested delivery is next month. This means I need an additional filter for the requested delivery which refers also to the selected month. Is that possible?
- bendejnp
Hey guys, does anyone else have an idea? 🙂
