Forum Discussion

fceusters's avatar
fceusters
Regular Visitor
5 years ago

Converting string expression to formula

Hello, I want do something with PowerPivot/DAX for designing a model that can calculate a composition of existing measuring points. I explain my setup a little One table consists of all meter...
Need Help
PhilipTreacy's avatar
PhilipTreacy
Super User
5 years ago

Hi fceusters 

Can you please share some actual data.

Qs: If your expresson is m0001 + m0002, how do you know which value for m0001 and m0002 to use?  Does each meter ID appear only once in the meter_id column?

Regards

Phil

  • fceusters's avatar
    fceusters
    Regular Visitor
    5 years ago

    Hi Phil,

    Tanks for the quick respons,

    These meter_ID's are connected to to the table with all monitored data ("SQL")

    A sample file with randomized data, and only an example meters structure you can find in:

    https://we.tl/t-tpTNu0OfPT

    Let me know if I can explain more

    Regards,

    Frank

    • v-yingjl's avatar
      v-yingjl
      Community Support
      5 years ago

      Hi fceusters ,

      Seems that not certain what is your expected output based on your description.

      Could you please consider combining it with your sample data or some screenshots about your expected output in the table for further discussion so that members in the community could help you better.

       

      Best Regards,
      Community Support Team _ Yingjie Li