Forum Discussion
Helper IYoY % variance in a Card visual ?
Hi LuisNC,
I created an example based on a public database (North Wind).
Note, you won't be able to refresh the data since it is pointing to a DB on my computer. But you should be able to open the file and look at how the measures work.
Link to file: https://1drv.ms/u/s!ApozY8vVlQj8hEr9UBKeL7Fh6DTJ?e=uc5QXT
Let me know how it goes.
Helper IHello Alan
I have tried the formula, and again it doesn't work 😞
Please see a screen shot below:
I have put the formula in a Card to try it. There's no red underline so I guess the formula is OK?
However there's an error message in the Card after adding the measure:
How could I make it work??
Many thanks in advance for your help 🙂
Resolver IVHi LuisNC,
I created an example based on a public database (North Wind).
Note, you won't be able to refresh the data since it is pointing to a DB on my computer. But you should be able to open the file and look at how the measures work.
Link to file: https://1drv.ms/u/s!ApozY8vVlQj8hEr9UBKeL7Fh6DTJ?e=uc5QXT
Let me know how it goes.
- LuisNC
Dude it seems to work now 🙂
And furthermore I think I understand the code lol
Many thanks for your help and your time!!
- AlanFredes
Thanks, LuisNC I appreciate it.
- AlanFredes
Would appreciate a Kudos.