Basic DAX filtering with CALCULATE and ALL functions

Recently I helped a few reporters get their first taste of building reports using Power BI. Power BI provides sophisticated filters and expressions that help you get the most of your data. In this post I’ll focus a little on the expressions you can use to create custom calculations in Power BI. The expressions are defined in a…

1

Finding the Latest Date in Power BI Desktop

One common question I get is how to do date filtering in Power BI.  In a previous post, I showed how to make filters that show if a values occurred in the last 30 days, in the last month, in the last 12 months, or in the current year.  This post show how to show…

2

Power BI Dynamic Date Filtering

One question I get from time to time is how to filter to the last week’s worth of data automatically in Power BI.  You might want the last 7 days, this week, this month, etc.  You can make it fully dynamic by combining the technique Matt Masson describes here to create a date table and add…

2

Year over Year in DAX – SAMEPERIODLASTYEAR needs a filter scope

This week I’m working to create a measure to count the total commits in a repository.  I thought it was working until I looked at the grand total and found something was off.    For the case of Grand Total, the value was mysterious. These were the measures I was using.  Total commits YoY% old:=DIVIDE([Total commits]-[Total Commits Same Period Last year],[Total…

0