Hi, I got different tables in my reports but in each of them I use a calculated column where I create the variable: VAR Version = 787_501.
I will need to change this sometimes, and I would like to know if there is a way to declare a variable in only ONE table, and use it in the others, and if no, is there any way to make something like that?
If I understand you correctly, [Var Version] is a constant. Then you can either have it in a table designated for this constant, or you can add it to just one of the table, and create calculated columns in the other tables like this:
You understood perfectly, when I first read your comment , I thought : yes that's it. BUT it seem like it doesn't works... I've created a table "Version" with only one cell called " "787_501" ", I've tried just to use your formula and return it to see if it works as intended: And it does... But when I use the formula in my other tables like this:
It doesn't works, there is no error but I have a different result from before in my column... I don't understand why.
Thanks for the help! The formula return the correct value but it seem like it does not work with my filter.. To be more precise, only this part of the formula is working, (so where I do not use the variable).
Is there a problem with my way to concatenate ? For example it should write "test 787_501\Development" When I use: VAR Versions = "787_501" it works , but when I use
VAR Versions = LOOKUPVALUE('Version'[Version];'Version'[Colonne];1) which actually returns: "787_501" , I've tested it, it does not works...