Power BI - Filtering sales dates using two different dates

Description
This Power BI pre-built demo template demo uses calculation groups created in Tabular Editor to filter sales data (fact table) by two different dates from the date table (dimension table).  


The template contains 2 report pages as follows:


1. Without Calculation Group


This page simply shows sales by the order vs. ship date in two different matrix visuals using DAX.


2. Using Calculation Group



This page updates a single matrix visual based on the item selected from the Calculation group slicer menu.


The objective of this template is to use the coding logic and apply it to your data. 


What's available?


Power BI modelled template that can be downloaded
4 x DAX formulas using USERELATIONSHIP
Pre-created Calculation Group for Sales by Order Date and Sales by Ship Date


To see the DAX code used simply click on the DAX measure.
To see the DAX expression used for the Calculation groups you would need to view it via Tabular Editor. For support questions, please use the direct messaging system on our Eloquens channel.


Developed by Arno Wakfer
Microsoft Power BI Data Analyst