Date Period - union

[ianboothman84]

Good Mornng 

I am creating a date period selection but need a little help.  So far i have this:

but i need three more levels:

1. Today

2. Last week

3. This week

this is my current code

Date Period =

UNION(

ADDCOLUMNS(

DATESMTD('Combined Data'[His_Calldate]),

"Type", "This Month"

),

ADDCOLUMNS(

DATESYTD('Combined Data'[His_Calldate]),

"Type", "This Year"

),

ADDCOLUMNS(

PREVIOUSYEAR(DATESYTD('Combined Data'[His_Calldate])),

"Type", "Last Year"

),

ADDCOLUMNS(

PREVIOUSDAY(DATESMTD('Combined Data'[His_Calldate])),

"Type", "Yesterday"

),

ADDCOLUMNS(

PREVIOUSMONTH(DATESYTD('Combined Data'[His_Calldate])),

"Type", "Last Month"

),

ADDCOLUMNS(

CALENDAR(MIN(ddate[Date]),MAX('Combined Data'[His_Calldate])),

"Type", "Show All"

),

ADDCOLUMNS(

CALENDAR(MIN(ddate[Date]),MAX('Combined Data'[His_Calldate])),

"Type", "Personalised"

)

)

can anyone help ? 

[ianboothman84 · Accepted solution]

Many thanks for your reply, after alot of research i have resolved the above. 

the below measure works great:

Date Period =

UNION(

ADDCOLUMNS(

{today()},

"Type", "Today",

"Order", 1

),

ADDCOLUMNS(

{today()-1},

"Type", "Yesterday",

"Order", 2

),

ADDCOLUMNS(

DATESMTD('Combined Data'[His_Calldate]),

"Type", "This Month",

"Order", 3

),

ADDCOLUMNS(

DATESYTD('Combined Data'[His_Calldate]),

"Type", "This Year",

"Order", 4

),

ADDCOLUMNS(

DATEADD(DATESMTD('Combined Data'[His_Calldate]),-1,MONTH),

"Type", "Last Month",

"Order", 5

),

ADDCOLUMNS(

PREVIOUSYEAR(DATESYTD('Combined Data'[His_Calldate])),

"Type", "Last Year",

"Order", 6

),

ADDCOLUMNS(

CALENDAR(MIN('Combined Data'[His_Calldate]),MAX('Combined Data'[His_Calldate])),

"Type", "Show All",

"Order", 7

),

ADDCOLUMNS(

CALENDAR(MIN('Combined Data'[His_Calldate]),MAX('Combined Data'[His_Calldate])),

"Type", "Custom",

"Order", 8

)

)

[v-jayw-msft]

Hi @ianboothman84 ,

Not very clear, can you show some sample data?

Best Regards,

Jay