Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
User | Count |
---|---|
98 | |
91 | |
84 | |
72 | |
67 |
User | Count |
---|---|
114 | |
103 | |
100 | |
72 | |
64 |