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.
Greeting lovely members .
i have a simple power bi report that i want to make it Dynamic .
My data base is simple , here is a sample :
let's say this is the table where it contains the data that i will use in my visuals , i have also a Date table and table for the teams .
what's im trying to make here is a measure that will filter automatically on the current month - 1 .
Ex : since we are in march , in one of my visual i want to show only the data of the current month - 1 which is Febrary . how can i acheive this .
also is it possible to set the YTD function dynamically ? stop the count at the current month-1 ?
Thanks all in advance .
Solved! Go to Solution.
Here is the trick :
Hi, @Anonymous
I hope I understand your question correctly.
please try to follow the below.
if it does not work, please let me know.
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
First of all Thanks for you answer .
i think i find a way to solve it , i was thinking to add a column in my Date table called Previous Month that have values (True or false) and based on that column i filter my visuals , can u help me build that calculated columns .
i was able to create a column that return true or false for the current month using this Dax funtion :
Here is the trick :
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 |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
88 | |
63 |