Piotr has attended:
Power BI Modelling, Visualisation and Publishing course
Power BI Modelling, Visualisation and Publishing course
Power BI Modelling, Visualisation and Publishing course
DYNAMIC DATES
Hello,
I would like to ask you if there is any way to create a formula in DAX, so the slicers for months can automatically be changed based on current month and rolling itself, without necessity to change them manually?
Kind Regards,
Piotr Jedrzejczyk
RE: DYNAMIC DATES
Hi Piotr,
Thank you for the forum question.
I believe that I have found an article with the steps you will need to do (link below)
https://docs.microsoft.com/en-us/power-bi/visuals/desktop-slicer-filter-date-range
Please let me know if it doesn't make sense.
Kind regards
Jens Bonde
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
