Need to declare Global variable in power bi DAX....

[Anonymous]

I want to declare global variable in Power bi so that I can use them while creating new measure using DAX. Can it be possible to do .

eg 

var Curdate= MAX(End of month Date)

[Mariusz]

Hi @Anonymous 

Unfortunately, you can not declare a global variable.

If you need to calculate a value only once when the model is loaded then DAX table or column is probably the best option.

If you need dynamic calculation then Measure can be recycled in another measure, but it will always recalculate.

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn