Forum Discussion
Solved
Multiple Date Column slicer
Hello i am relatively new to PowerBI and need some help I have 3 columns that have dates in them simillar to example below. How can i create One slicer to see every completion in October for exam...
You may try using CALCULATE Function to change the context.
https://www.sqlbi.com/articles/filter-arguments-in-calculate/
Here is an example of what i am trying to calculate. This would be a DATEDIFF between Completion X and Completion Y, however these columns were melted into an attribute->value columns when i did an unpivot action on them. Hope this helps...
| Completion X | Completion Y | Completion Z | Cycle Time X-Y | Cycle Time Y-Z |
| 10/1/2018 | 11/1/2018 | 12/1/2018 | 31 | 30 |
| 10/2/2018 | 11/12/2018 | 12/2/2018 | 41 | 20 |
| 10/3/2018 | 11/3/2018 | 12/3/2018 | 31 | 30 |
| 10/4/2018 | 11/14/2018 | 12/4/2018 | 41 | 20 |
| 10/5/2018 | 11/5/2018 | 12/4/2018 | 31 | 29 |
| 10/6/2018 | 11/16/2018 | 12/4/2018 | 41 | 18 |
| 10/7/2018 | 11/7/2018 | 12/4/2018 | 31 | 27 |
So you already have it. A DATEDIFF and that is it. What is the problem?