Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
i have the columns in table following
Engagement start time MIns(Duration ) Department
10.00 20 Sales
11.00 15 Marketing
12.10 60 Sales
want to show in a chart at which time call happened on daily basis(today)
or else time taken from engagement start time to end time to progress the call of each department.
Solved! Go to Solution.
Hi yuvarajg,
From your description, I create sample data to reproduce your scenario. Firstly, create column "Engagement end time" to get end time, and create table"TimeKey" to display 24 hours daily for further measure analysis.
Engagement end time = 'Table'[Engagement start time]+TIME(0,'Table'[Mins(Duration)],0)
Secondly, create measure "Call_Num" to count call using DAX function below.
Call_Num = CALCULATE(COUNT('Table'[Department]),FILTER(ALLSELECTED('Table'),'Table'[Engagement start time]<=MAX('TimeKey'[Time])&&'Table'[Engagement end time]>=MIN(('TimeKey'[Time]))))
Finally, choose Clustered column chart visual to show at which time call happened on daily.
Here is my pbix test file link: https://qiuyunus-my.sharepoint.com/:u:/g/personal/pbipro_qiuyunus_onmicrosoft_com/ETqD8p4o2WBMmqB5UZ...
If you have any other issue, please feel free to ask.
Best Regards,
Amy
Hi yuvarajg,
From your description, I create sample data to reproduce your scenario. Firstly, create column "Engagement end time" to get end time, and create table"TimeKey" to display 24 hours daily for further measure analysis.
Engagement end time = 'Table'[Engagement start time]+TIME(0,'Table'[Mins(Duration)],0)
Secondly, create measure "Call_Num" to count call using DAX function below.
Call_Num = CALCULATE(COUNT('Table'[Department]),FILTER(ALLSELECTED('Table'),'Table'[Engagement start time]<=MAX('TimeKey'[Time])&&'Table'[Engagement end time]>=MIN(('TimeKey'[Time]))))
Finally, choose Clustered column chart visual to show at which time call happened on daily.
Here is my pbix test file link: https://qiuyunus-my.sharepoint.com/:u:/g/personal/pbipro_qiuyunus_onmicrosoft_com/ETqD8p4o2WBMmqB5UZ...
If you have any other issue, please feel free to ask.
Best Regards,
Amy
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
111 | |
92 | |
84 | |
66 |