How to use two different date fields in Date range slicer

Hi Anonymous 

This is a common requirement and there are a couple of ways to achieve this, though for all of these you need to create a date table (e.g. see here for creating one in DAX)

Once you have this you have a few options:

1) Create two relationships between this date table and your main table on both date fields Only only one can be active (e.g. created date), or both can be inactive. You then need to active the relationship on demand in your DAX Formula using the USERELATIONSHIP function e.g. CALCULATE(COUNTROWS(Sales),USERELATIONSHIP(Date[Date],Sales[Created Date]). See here for details on this function

2) Create a copy of the date table by going to modelling -> New Table and setting the new table equal to the original one. One date table can be connected to created date and one to credited date. (This is best if you need to analyse the dates separately e.g. consider all those orders credited in one month which were created in another, though not so much if you want to look at both in a single graph/have the user select only one date range)

3) Have a single date table but don't create any relationships between this and the main table. Instead use a function in DAX to create a virtual relationship - e.g. TREATAS (see https://www.sqlbi.com/articles/propagate-filters-using-treatas-in-dax/).