Power BI 변수: 복잡한 수식 및 계산 간소화

### Power BI의 변수 이해: 복잡한 계산에 대한 간소화된 접근 방식
* ⚙ Power BI에서 변수는 **값을 저장하는 이름**으로, 복잡한 계산을 더 쉽게 이해하고 관리할 수 있게 해줍니다.
* 📊 변수는 `VAR` 키워드를 사용하여 정의할 수 있으며, **`VAR variable_name = 계산 표현식`** 형식을 사용합니다.
* 📈 예를 들어 수익률을 계산하기 위해 **수익, 원가 및 매출에 대한 변수를 정의**하여 수식에 사용할 수 있습니다.
* 🔢 변수를 사용하는 수익 백분율의 공식은 다음과 같습니다: **`변수 수익 = SUM(Profit), 변수 톱니바퀴 = SUM(Sales) - SUM(Profit), 변수 수익_퍼센트 = 수익 / 톱니바퀴 RETURN 수익_퍼센트`**입니다.
* 💡 변수를 사용하면 복잡한 계산을 더 작고 이해하기 쉬운 부분으로 나누기 때문에 **초보자도 쉽게 따라할 수 있습니다.**
* 🔄 반대로 변수가 없는 동일한 계산은 다음과 같이 작성됩니다: **'합계(수익) / (합계(매출) - 합계(수익))`**로 작성되는데, 특히 Power BI를 처음 사용하는 사용자에게는 해석하기가 더 어려울 수 있습니다.
* 🔍 변수는 특히 여러 단계가 포함된 복잡한 계산의 경우 **코드 가독성과 유지 관리성**을 향상시킵니다.
* 📈 변수를 활용하면 Power BI 사용자는 **DAX 수식을 간소화**하여 더 투명하고 쉽게 문제를 해결할 수 있습니다.

Power BI의 변수는 복잡한 수식을 단순화하여 계산을 더 쉽게 이해하고 관리할 수 있게 해주므로 전반적인 효율성과 이해도가 향상됩니다.

hi guys, in this session, we will discuss about the variables in Power BI. What variables will do for us in Power BI, let's see with some common examples. First, understand what a variable is. A variable is a kind of a name that stores your value. That means you can define any name which stores your data, and data is located in your memory. Any calculation can be performed which is going to affect your memory location. Now let's see, if I have a name 'a' and I have given here 255, meaning 'a' is the variable which holds your data 255. Anytime I'm going to write only 'a', it will result as 255. In the same way, if I'm going to write 'a b' is the name and defining 'b' as a variable and I am putting here a value like 12.24, meaning 'b' is the variable which holds 12.24 as a value. So, somewhere in a formula, we're going to write in Power BI Desktop, if we place 'a', meaning I am placing there 255. If we place 'b', meaning I'm placing there this value. You know what a profit

is, I'm going to show you using variables how we going to calculate a profit percentage. And for profit percent percentage, we need few components already meaning. In order to get a profit percentage, we need few components to have already meaning either I have profit or then I have cogs cost of good SS meanings whatever are buds associated with and what are the sales amount. Now I'm giving profit as a variable then just just write v. V is a shortcut of writing a variable in power VI. Once you write v a r at then profit that mean you are have defining a variable profit which holds what formula your sum of your sum of profit. This will give you the total total profit and this profit will have your sum of profit and this profit is your variable. Now I have sum of cogs meaning I am summing a total column of cogs which whatever value comes through this formula I have those as a single name cogs and Define here as a variable same for the sale sales and here I'm going to Define sum of sales meaning Sal is the

name of variable which I going to define as the sum of the whole column of sales. Let's see in Power VI desktop. Now I have Power V desktop open. Now I'm going to calculate a profit percentage. Right-click and create a new measure. And my measure is profit percentage. Now you know already that for profit percentage we need few components already gets calculated. Meaning either I have profit and COGS or sales amount or either I have COGS sales amounts then cross mark gross margin then we'll have the formula at gross margin divide by total COGS. So in this case I'm going to have first The Profit. So defining a variable where meaning you are defining a variable it's not necessary to write in lower cases you can write in upper cases also. I'm going to have 4et sum of profit. This is my profit but I going to calculate profit percentage so need another value which is COGS. Then define again COGS and how going to find COGS ERS I don't have COGS here do I have sales.

amount can I go for checking click this table icon here. You can check what are the attributes you have. I have here in the right side we have sales amount and the profit amount. If I'm going to profit minus to the sales, then we have C GS. So I am going to follow the same rule here. I have to find cogs meaning. So sum of sales amount minus sum of profit amount, this will give me a cogs. Now in this way, I have defined two variables. First is my profit, which results using this formula. Second cogs, which results by this formula. Then I have another formula to use profit by C GS. You're going to use again a new variable profit percentage, and this will come by using formula divided by profit divided by CS. So WR here profit, and now this profit variable is available as X as a prefix. So select this x profit because this X indicates that you have a calculation or Define a variable. So just select this one. Now select C GS. Now I have three variables in order to have profit percentage.

have the final result using this formula. But how can I show if I enter this? It will show you an error. So what will you do? There is a rule. See, I press enter. This giving error because whenever you use a variable, then you have to use return keyword. So write return. What formula you want to be return? This formula, because this formula will calculate profit divided by CS. This is what I expect as a profit percentage. So return this name. So write this profit percentage. Now hit enter. Now there is no error. I can format this by percentage because profit percentages are I have calculated. Now drag a card where I can show you what is my profit percentage. Here I have my profit percentage. I'm going to calculate the same profit percentage in either way. So just right click new measure profit percentage. I'm not going to use a variable in this time. Then you will see what the difference between a regular formula or a formula using variable. I'm going to divide first the sum of profit, comma. How we'll get the cogs? Then I have used sum of sales.

amount minus sum of profit amount. Now, this is my formula. This is my formula and I have used sum of sales amount and sum of profit amount. This makes our COGS. Then this will be the denominator and this will be your numerator. Then you will have the divide function. Then you will get a profit percentage. Now hit enter. Now change the format. Now draw a card so that you will have your profit percentage here. Now you can see you have the same result using two types of calculation. One calculation comes with what we have been doing as a regular formula and calculation comes up using variable. You can see when I use a regular formula, you can see just like a very a bunch of code. A layman or the beginner can't understand what is happening here. But in case of using variable, it is clearly visible that I'm going to create calculate the profit here. I'm going to calculate a COGS. Then I'm going to calculate a profit percentage. Then I want to return only this profit percentage. In this way, I get.

18.42. Which one you like? Just comment it. Variable makes your complex formula easy so that anyone can understand. Variables are very helpful when you are going to use a complex formula. But variable will broken down your complex formula a single formula into parts so that small small parts can make a complex formula. And those small parts is very understandable way so that anyone can understand. So variables are useful. Try to use variables every time. Thanks for watching.

power bi variables | variables in power bi | power bi | power bi tutorial for beginners'

Akhilesh Gupta

Power BI의 변수를 사용하면 메모리 내에 데이터 값을 저장하고 조작할 수 있습니다.

변수는 특정 값의 이름을 정의하고 수익률 계산과 같은 계산을 수행하는 데 사용할 수 있습니다.

변수를 사용하면 수익, 매출 원가, 판매 금액과 같은 구성 요소를 Power BI Desktop 내에서 보다 효율적인 방식으로 저장하고 작업할 수 있습니다.

Power BI Desktop에서 수익률 계산하기

수익률을 계산하려면 수익 합계, 판매 금액 합계, COGS의 합계라는 세 가지 변수를 정의해야 합니다.

그런 다음 정의된 변수를 사용하여 수익을 COGS로 나누어 수익률을 계산합니다.

수익률 계산을 위한 수식의 변수 사용

오류를 방지하려면 변수를 사용할 때 수익률을 계산하는 공식에 '수익률' 키워드를 사용하여 작성해야 합니다.

수식에 변수를 사용하면 더 복잡하고 해석하기 어려운 일반 수식을 사용하는 것과 달리 수익률을 결정하기 위한 명확하고 이해하기 쉬운 계산 프로세스를 제공합니다.

이 접근 방식은 프로세스를 단순화하고 특히 초보자가 더 쉽게 접근할 수 있도록 합니다.

복잡한 수식에서 변수 사용의 이점

변수는 복잡한 공식을 더 쉽게 이해하고 사용할 수 있게 해줍니다.

변수는 공식을 더 작고 이해하기 쉬운 부분으로 나누어 전체 공식을 더 쉽게 이해할 수 있게 해줍니다.

변수를 사용하는 것은 매우 유용하며 복잡한 수식을 다루는 모든 사람에게 권장됩니다.