Forum Discussion

Shahzz77's avatar
Shahzz77
Frequent Visitor
5 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
5 years ago

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

Shahzz77's avatar
Shahzz77
Frequent Visitor
5 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
    5 years ago

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