Forum Discussion

Anan2609's avatar
Anan2609
New Member
4 years ago
Solved

DAX Measure to increase column value

Hello People,   I am newbie to power bi , i need to create to measure which increases LineTotal in the Sales table by 2% here LineTotal is Column , I have attached screenshot ,Any help or suggesti...
Need Help
Tips and Tricks
  • ryan_mayu's avatar
    ryan_mayu
    4 years ago

    Anan2609 

    maybe you can try 

    measure=sum(LineTotal )* 1.02

ryan_mayu's avatar
ryan_mayu
Super User
4 years ago

Anan2609 

do you mean creating a column?

column=LineTotal * 1.02

If this not what you want, pls provide the expected output.

  • Anan2609's avatar
    Anan2609
    New Member
    4 years ago

    ryan_mayu No I want to create measure that  increases LineTotal column values by 2%,

     

     

    See this the task to complete, here it is mentioned to create measure(Target sales)

     

    Thank U😊

    • ryan_mayu's avatar
      ryan_mayu
      Super User
      4 years ago

      Anan2609 

      maybe you can try 

      measure=sum(LineTotal )* 1.02

      • salmon96's avatar
        salmon96
        New Member
        2 years ago

        How is it 1.02, can u elobrate