Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi community!. I'm preety new in Power BI and I am facing a problem with dates.
I need to achieve that a table shows the entire month based on the selected date by the user.
For example if the user selects from 07-01-2018 to 08-20-2018 I have to show in my table from 07-01-2018 until 08-31-2018.
Anyone can help here??
Attached is the link with my model.
Thanks in advanced!!!
https://www.dropbox.com/s/11rduwn9wifdlry/test1.pbix?dl=0
Solved! Go to Solution.
So typically what you need to do is get your date from your slicer in a VAR using SELECTEDVALUE or MAX from your slicer. Then you want to get the MONTH from that in another VAR. Use that value to FILTER ALL of your table to where your MONTH of your date column equals your second VAR (month of your selected value from your slicer). So something like:
So typically what you need to do is get your date from your slicer in a VAR using SELECTEDVALUE or MAX from your slicer. Then you want to get the MONTH from that in another VAR. Use that value to FILTER ALL of your table to where your MONTH of your date column equals your second VAR (month of your selected value from your slicer). So something like:
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
150 | |
115 | |
104 | |
89 | |
65 |