How to calculate a parameter for a report once using DAX and use the result in all visualisations?

[CloudMonkey]

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

[Greg_Deckler · Accepted 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?

[CloudMonkey]

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