CASE Statement to DAX help

[Etwa]

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

[MFelix]

Hi @Etwa,

Do a right click over the column and select Replace values.

Regards,

MFelix

[Etwa]

Hello

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?

[MFelix · Accepted 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

[Etwa]

Perfect then, thanks mate