Forum Discussion

Shahzz77's avatar
Shahzz77
Frequent Visitor
4 years ago

How to multiply single value from one coloum to another using dax

I want to make a calcultion in DAX which includes Multiplication of single value with rest column values For example in table Ans = (Percentage 2020*sales2021) + (Percentage 2019*sales2021) +(Perce...
Need Help
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
4 years ago

Have you tried to use the DAX formula I provided?  You'll need to adjust it according to your actual table and column names.

Shahzz77's avatar
Shahzz77
Frequent Visitor
4 years ago

Yes i tried but  it is showing error when i am selecting  columns in my table.

my actual table and colum names are

reserve =

Var y = selectedvalue(timeperiod)

return sumx (filter(table,year<y && year>y-6), percentage)* selectedvalue(sales)

 

It is showing error in filter table and also i am not able to select my percentage column.

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    4 years ago

    You need to create a measure and in it need to specify the actual table names.

    • Shahzz77's avatar
      Shahzz77
      Frequent Visitor
      4 years ago

      sumx (filter(table,year<y && year>y-6), percentage)* selectedvalue(sales)

      What is y-6 .. why it is used

      • lbendlin's avatar
        lbendlin
        Icon for Super User rankSuper User
        4 years ago

        You had indicated that you wanted to see the previous four years of data .