Power BI can pull in and analyze data from a variety of sources. And once loaded, Power BI will form data relationships wherever it can. Even so, new datasets are sometimes needed instead of data relationships. One way to create these new datasets is to use the INTERSECT() expression with dataset pairs. One business scenario, … Continue reading Power BI: Dataset Intersect(s)
Power BI Intersect
Power BI: Intersect w/ Netflix Viewing Data
Recap: Visuals were built in the previous Netflix Viewing Data blog, but no formulas. Still, presenting the year-to-year viewing counts in stacked bar charts was simple enough. And the drilldowns weren't bad... Note: The Netflix viewing history export only includes the first time something is viewed, not each time it is viewed. However, today I … Continue reading Power BI: Intersect w/ Netflix Viewing Data