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.
Need some help with building a case statement or something similar.
My information brought back is telemetry based and need to adjust where a cloumn content name is "Excel" I need it to add a new coloumn and rename it to "Microsoft Excel" (just an example). The coloumn with the data is called "Application".
Something in the line of Where solution name is "excel" then "MS excel"
Any help will be useful, thanks
Code below
let Source = Sql.Database("xx.xxx.xx.xx\Telemetry", "TELEMETRY"), dbo_Lookup_solutions = Source{[Schema="dbo",Item="Lookup_solutions"]}[Data] in dbo_Lookup_solutions
Solved! Go to Solution.
Hi @Etwa,
In the query mode, when you do a new step is like recording a macro everytime you update the refresh the DB, PB gets the data and runs one step after the other to have everything as you need to use in the visualizations, so it's and automation of the data treatement that is repeated over and over again at each refresh.
Regards.
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @Etwa,
Do a right click over the column and select Replace values.
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHello
Thanks for responding
doing that will help me for my current set but will I not have to do that if I refresh the DB again and new values get populated?
Hi @Etwa,
In the query mode, when you do a new step is like recording a macro everytime you update the refresh the DB, PB gets the data and runs one step after the other to have everything as you need to use in the visualizations, so it's and automation of the data treatement that is repeated over and over again at each refresh.
Regards.
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsPerfect then, thanks mate
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 |
---|---|
110 | |
95 | |
76 | |
65 | |
51 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |