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

Creating Power Query Custom Connectors

Eugene Meidinger shows how easy it can be to create a customer Power Query connector: When I heard about custom data connectors for Power Query, I had assumed there would be a lot of work involved. While there is definitely quite a bit of work in implementing advanced features like query folding,  creating your very first […]

Read More

Displaying Filters In Power BI Tooltips

Marco Russo shows how you can create a filter dump measure to show all active filters as part of your tooltip: The Tooltips can display a string with multiple lines. This is useful for the DumpFilters measure that creates a new line for every column with a filter. You might wonder why the DumpFilters measure […]

Read More

Categories

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