Forum Discussion
Dates in multiple columns
Hi, I have an Excel table with multible columns (created fiscal year, created fiscal quarter, created month, scheduled fiscal year, scheduled fiscal quarter, scheduled month, completed fiscal year, completed fiscal quarter and completed month. And for each (created, scheduled, completed) 0 for not count or 1 for count).
I like to have one slicer for fiscal year, one for fiscal quarter and one month for all the above columns. So when I click fiscal quarter 2, I see the created, scheduled and completed numbers. Hopefully my question makes sence?
| Activity | created Date (calendar) | Created fiscal year | Created fiscal quarter | Created month | Count created | Scheduled Date (calendar) | Scheduled fiscal year | scheduled fiscal quarter | scheduled month | Count scheduled | Completed Date (calendar) | Completed fiscal year | Completed fiscal quarter | completed month | Count completed |
| A | 30/08/2019 | 2019 | 2 | August | 1 | 0 | 0 | ||||||||
| B | 19/02/2020 | 2020 | 4 | February | 1 | 20/05/2020 | 2020 | 1 | May | 1 | 0 | ||||
| C | 19/05/2021 | 2021 | 1 | May | 1 | 10/06/2021 | 2021 | 1 | June | 1 | 15/06/2021 | 2021 | 1 | June | 1 |
I'm pretty new to Power BI so forgive my ignorance
Thanks
1 Reply
- lbendlin
Super User
Please read about the USERELATIONSHIP function for filter context modification.
