Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Date Period - union

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 ? 
 
 
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    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
    )
    )
     

     

     

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi Anonymous ,

     

    Not very clear, can you show some sample data?

     

    Best Regards,

    Jay

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    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
    )
    )