Power BI Quick Calc

Nicolo Grando talks about a couple of Power BI features, conditional formatting and Quick Calc:

If you select a text column you can:

  • Show only the first attribute
  • show only the last attribute
  • Count the attribute
  • Distinct count the attribute

If you select a numeric column you can:

  • Sum of value

  • find the minimum or maximum value

  • Average the value of column

  • standard deviation of value

  • Count the value

  • Distinct count of value

  • Variance fo value

  • Median of value

The screenshots are in Italian, but it’s pretty easy to get the context behind them.

Related Posts

Running R Scripts In Power BI’s Query Editor

Brad Lewellyn walks us through the process of executing an R script against a table in Power Query: If you aren’t able to open the R Script Editor, check out our previous post, Getting Started with R Scripts.  While it’s possible to develop and test code using the built-in R Script Editor, it’s not great.  Unfortunately, […]

Read More

Inactive Relationships In Power BI

Reza Rad explains the value of inactive relationships and shows how you can implement this in Power BI: As you can see this new type of relationship is different. It is dashed line, compared to the active, which was a solid line. This is an inactive relationship. You can only have one active relationship between […]

Read More

Categories

February 2017
MTWTFSS
« Jan Mar »
 12345
6789101112
13141516171819
20212223242526
2728