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,
I need to use a DAX formula to decide which month a report relates to. The formula gets a bit complicated to allow for where the current week straddles two months, so I'd like to avoid having to avoid keep repeating the logic in every DAX formula within every visualization. Please can you tell me if there is a way to resuse a parameter?
Thanks,
CM
Solved! Go to Solution.
Not sure there is enough information here so my suggestion is probably not going to be useful, but you should be able to create a measure that does what you want and then reuse that measure in other calculations or are you saying that you want to filter each visualization by some standard thing? Sample data, examples?
Not sure there is enough information here so my suggestion is probably not going to be useful, but you should be able to create a measure that does what you want and then reuse that measure in other calculations or are you saying that you want to filter each visualization by some standard thing? Sample data, examples?
Thank you Smoupre.
I've added a blank table called Parameters just to hold any calculated parameters (as measures) seperate to the other table, seems to work nicely.
Thanks,
CM
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 |
---|---|
107 | |
99 | |
76 | |
64 | |
58 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |