Forum Discussion
Anan2609
4 years agoNew Member
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...
ryan_mayu
4 years agoSuper User
do you mean creating a column?
column=LineTotal * 1.02
If this not what you want, pls provide the expected output.
Anan2609
4 years agoNew Member
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😊
- salmon962 years agoNew Member
How is it 1.02, can u elobrate
- SADHASIVAM2 years agoNew Member
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