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.
Hello,
please could somebody help me with my problem?
I have many XML files with call logs and one excel file with attendance of operators.
XML file contains ID of the phone, date of the call and some other stuff.
Excel file contains ID of the phone, date of the attendance of the operator, time from, time to (when the operator started and finished work that day) and the operator's name.
What I need is to add a new column in the XML files in Power BI and type in the name of the operator who managed the call. So it should search somehow the ID of the phone with the date and then check if the time is older or equal to the time "from" and simultaneously that the time is younger or equal to the time "to", if everything meet the conditions, than it should type in the column "name" the name from the row which met the conditions.
Is that possible in Power BI somehow? I hope it is because I need to automatize this process fullfully (with no manual step like preparing CSV files) so I would be able to create reports from the data.
Thank You!!!
Tereza
Solved! Go to Solution.
Hi @TessGaston
You may use SELECTEDVALUE Function. Show you an example as below:
Measure = MINX ( FILTER ( Excel, SELECTEDVALUE ( XML[Time] ) > Excel[Start] && SELECTEDVALUE ( XML[Time] ) < Excel[End] ), Excel[Name] )
Column = MINX ( FILTER ( Excel, XML[Time] > Excel[Start] && XML[Time] < Excel[End] ), Excel[Name] )
Regards,
Cherie
Hi @TessGaston
You may use SELECTEDVALUE Function. Show you an example as below:
Measure = MINX ( FILTER ( Excel, SELECTEDVALUE ( XML[Time] ) > Excel[Start] && SELECTEDVALUE ( XML[Time] ) < Excel[End] ), Excel[Name] )
Column = MINX ( FILTER ( Excel, XML[Time] > Excel[Start] && XML[Time] < Excel[End] ), Excel[Name] )
Regards,
Cherie
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 |
---|---|
96 | |
93 | |
82 | |
70 | |
64 |
User | Count |
---|---|
118 | |
106 | |
93 | |
79 | |
72 |