data transformation

4 Topics

Software Crash
Hello, My name is Fatima, my PoweBi keeps crashing when I click on the transform data, what can I do about this? Regards, Fatima.
Solved
FatimaBatool
2 years ago Place Desktop
605Views
0likes
2Comments
Converting Data Per Minute to Hourly in Power BI
I need help with data transformation in Power BI. The data I have is stored in the data source with a minute-level granularity, but I want to display the data in the report on an hourly basis. How can I perform this transformation using Power Query Editor to show the data in hourly intervals with the appropriate aggregation (e.g., average)? Thank you for your assistance!
srymhrdka
3 years ago Place DAX Commands and Tips
707Views
0likes
2Comments
retrieving values in a row when the value of one column is equal to the value of another column
I've used dummies data to show the question. Id Index ProjectId Predecessors 1 1 66 5 2 5 66 3 I need to find for each predecessor, the index equal with predecessor value then compare the ProjectId in the predecessor row and the project id of the index(that is equal with predecessor index) if they are equal then return the Id of the index. in this example: I read first row =>index =1 predecessor = 5 I look for 5 in all index column => go to index = 5 if projectId(index = 5) = projectId (index = 1) then return Id (index = 5) Thanks for taking time, in advance.
Solved
Lidiar
5 years ago Place DAX Commands and Tips
640Views
0likes
2Comments
History data load from SAP HANA source
Dear Team, How to load the history without impacting the source data server (SAP HANA) performance as we have large amount of data (Roughly about 60 Million records with 102 columns) Any suggession can be appriciated. Thanks in advance, Vara
vkarumanchi
6 years ago Place Report Server
522Views
0likes
0Comments