PowerPivot exercises on CALCULATED COLUMNS

This page lists the 7 exercises about Calculated columns in PowerPivot on our website:

Software: PowerPivot
Version: Excel 2010 and later
Topic: Calculated columns
Level: Relatively easy
Course: PowerPivot / Excel Power BI
Exercise: Total sales by weekday, using simple two calculated columns.

Go to exercise ...

Software: PowerPivot
Version: Excel 2013 and later
Topic: Calculated columns
Level: Relatively easy
Course: PowerPivot / Excel Power BI
Exercise: Create an aggregator column to sum transaction values by weekday in a pivot table.

Go to exercise ...

Software: PowerPivot
Version: Excel 2016 and later
Topic: Calculated columns
Level: Relatively easy
Course: PowerPivot / Excel Power BI
Exercise: Create two new calculated columns in a table, using RELATED and CONCATENATE.

Go to exercise ...

Software: PowerPivot
Version: Excel 2016 and later
Topic: Calculated columns
Level: Average difficulty
Course: PowerPivot / Excel Power BI
Exercise: Divide shopping centres into the circles of hell, using the IF and the SWITCH functions.

Go to exercise ...

Software: PowerPivot
Version: Excel 2010 and later
Topic: Calculated columns
Level: Average difficulty
Course: PowerPivot / Excel Power BI
Exercise: Divide years into bands using SWITCH and calculated columns.

Go to exercise ...

Software: PowerPivot
Version: Excel 2013 and later
Topic: Calculated columns
Level: Average difficulty
Course: PowerPivot / Excel Power BI
Exercise: Calculate age bands for different dates using the SWITCH functon.

Go to exercise ...

Software: PowerPivot
Version: Excel 2010 and later
Topic: Calculated columns
Level: Harder than average
Course: PowerPivot / Excel Power BI
Exercise: Summarise sales by status of animal, using calculated columns.

Go to exercise ...

You can search our full list of Power BI exercises here, or why not have a look at our other Power BI training resources?

This page has 0 threads Add post