While making external table views, If we are using two or more than two tables it is normal to use 3 aliases with their respected key comparisons & having more than 2 joins But in the case of 2 tables whether it is 1 table+1 view or both tables or both views & we want a key comparison for more than two different conditions then for that we have to consider 3 or more aliases concerning conditions or columns where we want changes just simply give the main table or view different aliases with different key comparisons, The benefit is that it will consider different conditions for different columns & We can make a view with desired conditions for all columns.

Here is a better idea to take date slicer into the next level simply with DAX queries,

You can select the previous year, previous month, previous quarter, month till date, quarter till date, year till date, yesterday, previous week & last n no. of days data.

DatePeriods =

VAR _datetable = DateTable

VAR _today = TODAY()

VAR _month = MONTH(TODAY())

VAR _year = YEAR(TODAY())

VAR _thismonthstart = DATE(_year,_month,1)

VAR _thisyearstart = DATE(_year,1,1)

VAR _lastmonthstart = EDATE(_thismonthstart,-1)

VAR _lastmonthend = _thismonthstart-1

VAR _thisquarterstart = DATE(YEAR(_today),SWITCH(true,_month>9,10,_month>6,7,_month>3,4,1),1)

RETURN UNION(

ADDCOLUMNS(FILTER(_datetable,[Date]=_today-1),”Type”,”|Pervious Day”,”Sort”,6

),

ADDCOLUMNS(PREVIOUSYEAR(DATESYTD(‘Date’[Date])),

“Period”, “|Previous Year”, “sort”, 5

),

ADDCOLUMNS(PREVIOUSMONTH(DATESMTD(‘Date’[Date])),

“Period”, “|Previous Month”, “Order”, 3

),

ADDCOLUMNS(FILTER(_datetable,[Date]>_today-7),

“Period”, “|Last 7 Days”, “Order”,2

),

ADDCOLUMNS(PREVIOUSQUARTER(DATESQTD(‘Date’[Date])),

“Period”, “|Previous Quarter”, “Order”, 4))

You can also add different date functions as per requirements.

Thank you

As per my view, there are a lot of support libraries, you can get support everywhere, it is highly productive as compared to other languages(programming),it requires less time, effort and main thing less lines of code to perform same operations performed in other programming languages