Forum Discussion

georgy_gryaznov's avatar
georgy_gryaznov
Frequent Visitor
7 years ago
Solved

Filtering and grouping dataset with pivoting

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

Need Help
  • v-yuta-msft's avatar
    v-yuta-msft
    7 years ago

    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

1 Reply

  • v-yuta-msft's avatar
    v-yuta-msft
    Community Support
    7 years ago

    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