15 min roll up to hour
Help! I'm using PowerBI RS (May 2023) with DirectQuery to Avaya CCMS database (odbc conncetion) I have 15 minute interval data that I'm trying to roll up to hourly data. I need to create an average talktime column which is calculated as [talktime] / [callsAnswered]. I can do this for 15 min intervals but I can't get it to roll up to the hour as I can only seem to have it calculate an average of an average (i.e. calculates the talktime/callsanswered for each row then sums the total together, this could be 4+ rows for every skillset every hour depending on how the data was recorded by the phone system. Since is over multiple skillsets so there will be multiple rows with the same date and time but different skill name for the row. I'd toyed with the idea of making a concatenated column with hour, skillset & date as an identifier for the skillset and the day and using that as a filter for CALCULATE where a concatenated expression of the same values had to equal the concatenated column but I don't know if that would work.EDIT it didn't. Here's a screenshot showing the layout I'm going for, the next column in the table needs to be a calculation of the filtered data on the visual's row. Here's a sample from the dataset
Power BI report server Direct query: getting data form one direct query to another direct query
Hi Team, I have 3 tables one with Employee detail(employee ID, Name, Email columns) --> this table accessiable to all. data_access (employee and city) and another table with Country_revenue (Country, continent, revenue amount columns) deatils --> these table is accessible only for specific account when we pass the employee Id in the SQL pacakge(Pkg_data.country_data (Email)) I tried 1. DAX fucntion Userprincipalname to use as a parameter, but direct query (power editor) doesn't support it. 2. list.max but 'Failed to save modifications to the server. Error returned: 'DirectQuery partition 'xxxx-x56565x7575757575x757575' has '2' datasource reference(s) in its expression which is not allowed. '' Can you please help, how to pass Email into this?
