DAX Measure to increase column value

[Anan2609]

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 suggestion i need to complete the task.

Thank u in advance

[Bhav]

I am new dax learner, i don't know how we can use all dax in one measure, but i have created multiple measure and got result.

1.    Total sales = SUM(Sales[LineTotal])

2.    Total sales*2 = [total sales]*2

3.   2% of total sales = [Total sales*2]/100

4.   Target  = [total sales]+[2% of total sales]

[demouser]

TargetSales = SUM([LineTotal]) * 2.00

Use this..!

[ryan_mayu]

@Anan2609 

do you mean creating a column?

column=LineTotal * 1.02

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

[Anan2609]

@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 · Accepted solution]

@Anan2609 

maybe you can try 

measure=sum(LineTotal )* 1.02

[salmon96]

How is it 1.02, can u elobrate 

[SADHASIVAM]

Yeah So we need to increase the column value by 2 percent right so it is 
Linetotal + Linetotal*0.02 
Linetotal(1+0.02)
Linetotal*1.02
sum(Linetotal)*1.02 .
I Hope this helps