Filter data from table from two rows
I have a table visualization and there are companies listed and the first row shows 0 under some columns. So, I want to filter out that row the rows and column that have 0s. Then I want to go to the last column which is blank for the most part, but when it show the value, I want to pull that data in that column and also show some other columns associated with it. This two sets of rows should merge as one row in the end. The screen shot is shown I hope this is enough information. Thank you!
I can not refresh the data in Power Bi Desktop.
Help. I can not refresh the data in Power Bi Desktop. Here are two screen shot. One of my Excel database. One of PowerBi Desktop with the error message. It says: "We did not find the column" Mail "of the table". But, as it can be seen on the screen shot there no There is no "Mail" column to fill in Power Bi. But rather "Current Email". And as we see on the Excel table of the data it does appear a column "Current Email". What can I do to refresh my PowerBi ?
