Goals
Share my experiences in analytics, reporting through visualization, and self-service tools.
Enjoying Pirogi in Poland
Linkedin
Meta
Recent Comments
Meta
Tag Archives: Example
First Month Gifts Using Generate Function
Often we need to derive first-month sales/donations. In the sample dashboard that I built using public FEC data, there are donors with multiple donations. The formula below allows determining donations in the first month since the first donation in a … Continue reading
Posted in Dax Code Patterns
Tagged dax, Example, Generate, Power BI, Sales 1st month
Comments Off on First Month Gifts Using Generate Function
Using CrossFilter To Alter Relationship
I recently came over an example of CROSSFILTER function in DAX. While not very common I can see a lot of potential in certain circumstances. Essentially, in a measure, it temporarily alters relationships. In most cases, there is a fact … Continue reading
Posted in Dax Code Patterns
Tagged CROSSFILTER, dax, Example, optimization
Comments Off on Using CrossFilter To Alter Relationship