Forum Discussion

FZOU's avatar
FZOU
Helper IV
6 years ago
Solved

Dax Multiplication

Hello,   I'm getting a weird result from a simple dax formula i tried so many formula by summing the age by creating a column with the 12 number but without result. I'm trying to calculate the a...
Need Help
  • MFelix's avatar
    MFelix
    6 years ago

    Hi FZOU ,

     

    I'm assuming that you have several lines with 3 years, 4 years and so on correct?

     

    So when you do a SUM you are getting the sum of all those lines and then multiplying that by 12.

     

    Looking at the numbers I think you have 15.552 lines with the value 3.

     

    Try the following code:

    AgeMonth= SELECTEDVALUE(DemandsMontlhy[AgeYear])*12
MFelix's avatar
MFelix
Super User
6 years ago

Hi FZOU ,

 

I'm assuming that you have several lines with 3 years, 4 years and so on correct?

 

So when you do a SUM you are getting the sum of all those lines and then multiplying that by 12.

 

Looking at the numbers I think you have 15.552 lines with the value 3.

 

Try the following code:

AgeMonth= SELECTEDVALUE(DemandsMontlhy[AgeYear])*12
FZOU's avatar
FZOU
Helper IV
6 years ago

MFelix  it work,i did not know that,thank you very much 🙂