Change table from mysql data base
Hello I am using MySql to get the data to use in my power bi project. I want to use the same Report for all the tables that I have in my data base: How can I change the table from the data base from the report section? : I know I can do it from the advanced editor of the query editor but I don´t want to do that in this way.Calculate production - investment only for the first year
Hello I need to calculate the difference between production and Investment but only for the year In which the production starts, that means that Production > 0, using DAX like in the following table, can you help me? Product Year Production Production - Investment Investment A 1 100 -600 700 A 2 50 50 A 3 20 20 B 1 0 0 B 2 500 -200 B 3 400 400 C 1 0 0 C 2 100 -600 C 2 789 798
