Forum Discussion

LuisNC's avatar
LuisNC
Icon for Helper I rankHelper I
3 years ago
Solved

YoY % variance in a Card visual ?

Hello dear Community, I am pretty new to Power BI. I need to calculate the YoY % change for the number of orders in a dataset. The order ID is a column with 3055 unique values, and there are a few...
Need Help
  • AlanFredes's avatar
    AlanFredes
    3 years ago

    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.

AlanFredes's avatar
AlanFredes
Icon for Resolver IV rankResolver IV
3 years ago

Hi Luis,

 

The two options were not supposed to be applied together.
The DAX formula I sent should be used without the filters added. Also, the table and column names don't seem to be completely correct. My keyboard doesn't write the " ' " correctly so you will need to rewrite the table and column names. Make sure the red underscore gets cleared, that is how you know the syntaxis is correct.

And thanks for catching the order_UD error it is in fact a typo and should be Order_ID.

 

 

LuisNC's avatar
LuisNC
Icon for Helper I rankHelper I
3 years ago

Hello 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 🙂

  • AlanFredes's avatar
    AlanFredes
    Icon for Resolver IV rankResolver IV
    3 years ago

    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.

    • LuisNC's avatar
      LuisNC
      Icon for Helper I rankHelper I
      3 years ago

      Dude it seems to work now 🙂

      And furthermore I think I understand the code lol

      Many thanks for your help and your time!!

      • AlanFredes's avatar
        AlanFredes
        Icon for Resolver IV rankResolver IV
        3 years ago

        Thanks, LuisNC I appreciate it.