Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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:
User | Count |
---|---|
107 | |
88 | |
81 | |
76 | |
73 |
User | Count |
---|---|
112 | |
104 | |
96 | |
74 | |
66 |