Forum Discussion
Solved
dynamically set current date to slicer date selection
Hello, I have a slicer with Date column And I will show a snap shot of my calendar table from the query editor. I want the value of the "current date" to be what ever val...
Hi kaileena ,
Agree with edhans that there is no way to pass the selection in slicer back to Power Query though.
You may create a measure to dynamically get the offset:
Offset = DATEDIFF(MAX('Table'[Date]),MAX('Dates'[Date]),MONTH)Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi kaileena ,
Agree with edhans that there is no way to pass the selection in slicer back to Power Query though.
You may create a measure to dynamically get the offset:
Offset = DATEDIFF(MAX('Table'[Date]),MAX('Dates'[Date]),MONTH)
Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hello! thank you.
