this video is a quick pit stop where I
show you how to create a power bi
calculated column before I move on to my
favorite topic power bi measures keep
watching hey hey hey we are ready to
define a first calculation so here we
are in our sales table and we have our
sales amount and tax amount and the
first calculation will try to define is
a total sales amount which is the sum of
both of these now if you notice up at
the ribbon over here in the modeling tab
you have this calculation pane and
ignore this new table for now but really
the key ones are either you can define a
new measure or a new column all right so
first of all let's save this file and
we're going to go take a peek at the
file itself so this is three seven six
one kilobytes I'm going to write that
down
there's my notepad there we go three
seven six one okay be perfect okay so I
have that and I'm going to come back
here and I'm going to define a new
column alright this is just one of the
available calculation types so I'm going
to say new column and great I see this
new column added here but really the key
is is the formula bar here so I have
column and I can change that name and
I'll say total sales amount all right
total sales amount equals and I'm going
to use the column name sales amount
perfect I see you notice that it
autocompletes
let's put that closer up so I'm here in
my formula bar and let's see that again
so if I were to type in sales amount you
just narrows it down and then I can hit
the tab key
on my keyboard to complete it and plus
the other one is tax amount and there we
go and I can just hit enter and my
column has been at it right it's just
summing these two up change the
formatting if I wanted to change that to
zero decimal places make it look a
little cleaner and if you notice here
that it has a slightly different icon to
indicate that it is a calculated column
so total sales amount but what I really
wanted to show you was that I'm going to
save this file again and if I go back
notice the size here is three seven
eight nine all right so that's that's
key that after I added a calculated
column the size grew or one you can see
that there you go one front three seven
six one two three seven eight nine now
this is a very very small data set any
real production data set is going to be
far larger than this and I'm going to
come back and talk about the impact of
this now by the way so between these two
new measures and new column I see Excel
users inevitably gravitate towards new
column and they keep creating these
columns and additional columns and write
and they keep keep going you creating
these here which may feel natural for
Excel user but it's not really the way
you want to go with power bi power bi
desktop any mat you want to perform
typically you would want to create a
measure now there are going to be
scenarios where you want to create a
calculated column we'll cover those
later but I would say your default
should be that if there's a calculation
it should be a measure
hey keep watching more videos and keep
learning power bi but if you did enjoy
this video I would love to hear from you
so leave a comment like subscribe all
the good stuff while we're on my friends