Forum Discussion
bendejnp
Helper I
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...
amitchandak
Super User
Super Userbendejnp , 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?