Filtering and grouping dataset with pivoting

[georgy_gryaznov]

Hi, could you please help me to make a report .
For example, i have a data source of events "assigning managers for customers"
Customer Assigned Assign_date

Mr.Smith Georgy 09.01.2017

Mr.Smith Rob 01.02.2017

Mr.Brown Tedd 08.01.2017

Mr.Brown  Georgy 01.02.2017

and if I set filter Assigned = Georgy and period_start = 01.01.2017 and period_end = 28.02.2017, my report should look like this

Mr.Smith Georgy 09.01.2017 - 01.02.2017

Mr.Brown Georgy 01.02.2017 - now

The need is to show the participation of the Manager in all customers for the period.

Thanks

[v-yuta-msft · Accepted solution]

Hi georgy_gryaznov,

I would recommend you to create a measure or calculate column using DAX below and check if it can meet your requirement:

Period =
VAR Start_Date =
    CALCULATE ( MIN ( Table[Assign_date] ), ALLSELECTED ( Table ) )
VAR End_Date =
    CALCULATE ( MAX ( Table[Assign_date] ), ALLSELECTED ( Table ) )
RETURN
    CONCATENATEX ( Table, Start_Date & "-" & End_Date )

Regards,

Jimmy Tao