One user described the problem on the official forum: So, the OP wants to add a new column that will allow a new calculation. Today we will show you how to do that in a few easy steps.
Steps to add a calculated column in Power BI
1. Create a measure using DAX
DAX stands for Data Analysis Expression and it is the formula language in Power BI. Here you can add functions and formulas for your columns like in the image below. In the upper case (second arrow), add the following: Adapt the values to make the formulas work for your case. This guide will make you a better Power BI user. Do check it out now.
2. Apply the measure directly to the slicer
You can also modify the measure as below: The second measure applies directly to the slicer, so you can compare different months, such as the first and the last.
Conclusion
With calculated columns, you can organize and visualize your data in various ways. But first, you need to know a few basic principles and measures for these columns. They are pretty easy to work with once you get to understand them. How do you add calculated columns in Power BI? Do let us know in the comments section below! RELATED ARTICLES YOU NEED TO CHECK OUT:
How to add filters in Power BI [EASY STEPS] 5 free cloud accounting software to keep your books updated on the fly Stuck with Math? Use these best software to write mathematical equations
SPONSORED
Name *
Email *
Commenting as . Not you?
Save information for future comments
Comment
Δ
