Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi guys, I have a task where I need to filter automatic dates when I log into the report, so I need it to appear without having to click anything, is there any filter that does this or some calculation? I tried to use Relative Date, formulas in Dax and m language, but none worked.
I thank you for your help.
Hi @jennifer_reis,
Would be useful to include some details about your model and some sample data.
If you add a column to your date table you can acheive this.
This video may help.
https://www.youtube.com/watch?v=VaJ10ilXp6Y
Have I solved your problem? Please click Accept as Solution so I don't keep coming back to this post, oh yeah, others may find it useful also ;). |
If you found this post helpful, please give Kudos. It gives me a sense of instant gratification and, if you give me Kudos enough times, magical unicorns will appear on your screen. If you find my signature vaguely amusing, please give Kudos. | Proud to be a Super User! |
Please check this blog Default Dynamic Date Filters In Power BI - Microsoft Power BI Community
Hope it helps!
Ritesh
Mark my post as a solution if it helped you| Munde and Kudis (Ladies and Gentlemen) I like your Kudos!! !!
My YT Channel Dancing With Data !! Connect on Linkedin !! PL 300 Certification Series