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/
my problem now is i did an unpivot action and now my columns look like this
| Completion Type | Completion Date |
| Completion X | 10/1/2018 |
| Completion Y | 11/1/2018 |
| Completion Z | 12/1/2018 |
I am trying to pivot these columns back but having trouble retainig the values. Is there a different way to calcuate the DATEDIFFs between these completion types withouth having to pivot the columns back?
You may try using CALCULATE Function to change the context.
https://www.sqlbi.com/articles/filter-arguments-in-calculate/