Excel 2013 Power BI Tools Part 8 - Calculated Columns in PowerPivot

By Andy Brown

This tutorial explains how to create calculated columns within PowerPivot, using functions like IF, SWITCH, RELATED and BLANK. In many ways calculated columns are similar to formulae within Excel - there's even a function wizard that you can refer to when you get stuck.

[yamax]

I am delighted to watch all power pivot videos. They widen my knowledge on useful tricks and shortcuts that I didn;t know before. Thanks for making the videos.

[markschild]

all of your video tutorials and brilliant and have been invaluable for me

[ahmedal-dossary]

Thanks for this wonderful video.

I need to create +140 calculated columns and use them to develop measures.

I’ll create a loop to have the measures, but I’m not aware how to do the same for calculated columns. It’s very awkward in data model that you don’t get to calculate the cells as quickly as in excel formula bar.

Any idea how to create the calculated columns in a faster manner?

[waltermiguelfernandez]

Do you have the same video in spanish?

[sharnumuganoor]

Hello..

Please help me achieve the below exact excel formula in Power BI

Col1 Col2
A 3
A 2
A 1
B 2
B 1
C 1