Forum Discussion

Etwa's avatar
Etwa
New Member
8 years ago
Solved

CASE Statement to DAX help

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's avatar
    MFelix
    8 years ago

    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

4 Replies

  • MFelix's avatar
    MFelix
    Super User
    8 years ago

    Hi Etwa,

     

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

     

    Regards,

     

    MFelix

    • Etwa's avatar
      Etwa
      New Member
      8 years ago

      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's avatar
        MFelix
        Super User
        8 years ago

        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