Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Indexcolum or not?

Hello,   I want to calculate the difference between different periods, like a sum of year to year(13 periods), a sum of period(1 period versus previous period). I have 2 tables. 1 table with data a...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    Hi Anonymous 

     

    Please find my attached file.

     

    https://www.dropbox.com/s/x0bgw6swyq6jtmw/Question%20indexcolum.pbix?dl=0

     

    I have added an index column ( starting from 1) in Data Table.

    I have also added the new columns which has formulas.

     

    The cards Visuals shows the Variance of year Euro and % variance of the same.

     

     

    Let me know if this works for you.

     

    Thanks,

    Tejaswi

     

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Anonymous 

Hi Tejaswi,

 

Thanks for your reply. I tried the code but i get stuck at the firts line.

im not sure what to do with the index. 

 

Maybe you can take a look in my PBIX file?

Link to PBIX

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi Anonymous 

 

Please find my attached file.

 

https://www.dropbox.com/s/x0bgw6swyq6jtmw/Question%20indexcolum.pbix?dl=0

 

I have added an index column ( starting from 1) in Data Table.

I have also added the new columns which has formulas.

 

The cards Visuals shows the Variance of year Euro and % variance of the same.

 

 

Let me know if this works for you.

 

Thanks,

Tejaswi