Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to 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
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