Forum Discussion

pgnilesh's avatar
pgnilesh
Regular Visitor
8 years ago

Calculation Based on Values in PowerBI

Hi Team,

 

I am new to PowerBI and started learning it today only. I have a simple table like this. There are 6 tags appearing for the same date time. Requirement is I need to put some calculation say for example XYZ = 3505FT101F_CV + 35F1821F_CV. And this should be added for each time. I know there are somethings like adding new measure or calculated column but this is all based on columns. I need to perform this calculation based on value. Please suggest.

 

Tag_DateTag_NameTag_Value
4/9/18 9:00 AM3505FT101F_CV136.624876
4/9/18 9:00 AM35F1821F_CV5.29965
4/9/18 9:00 AM35FI14501F_CV119.59756
4/9/18 9:00 AM99PESWFF_CV0.008763643
4/9/18 9:00 AM99DEGRHPF_CV0
4/9/18 9:00 AM35W11_IHPSTEAMF_CV9.988991792
4/9/18 10:00 AM35FI14501F_CV119.2965316
4/9/18 10:00 AM3505FT101F_CV136.6248037
4/9/18 10:00 AM35W11_IHPSTEAMF_CV10.01061661
4/9/18 10:00 AM99PESWFF_CV0.009128429
4/9/18 10:00 AM99DEGRHPF_CV0
4/9/18 10:00 AM35F1821F_CV5.3100361
4/9/18 11:00 AM35W11_IHPSTEAMF_CV10.00146312
4/9/18 11:00 AM3505FT101F_CV139.1520708
4/9/18 11:00 AM35FI14501F_CV122.0044979

 

Thanks,

Nilesh

3 Replies

  • vanessafvg's avatar
    vanessafvg
    Community Champion
    8 years ago

    pgnilesh

     

    not quite sure what you asking do you want to hard code the tag value in the calculation or do you want to aggregate all the values for the same tag?

    • pgnilesh's avatar
      pgnilesh
      Regular Visitor
      8 years ago

      Hi Vanessafvg, vanessafvg

       

      Thank you for your reply. What I need to do is really add 1 more record say XYZ for each Tag_Record_Date_Time which is a calculation like XYZ = 3505FT101F_CV + 35F1821F_CV. I think we can add a measure. But Measures are based on column is what I have understood. Then I can use Matrix Visualization to show All Tags as column which will have existing tags as shown in the table + the calculated tags. And Rows will be time.

       

      Thanks,

      Nilesh

      • pgnilesh's avatar
        pgnilesh
        Regular Visitor
        8 years ago

        vanessafvg,

         

        Just to explain more clearly, want to convert the table mentioned in my 1st post to this:

        Tag_DateTag_NameTag_Value
        4/9/2018 9:003505FT101F_CV136.624876
        4/9/2018 9:0035F1821F_CV5.29965
        4/9/2018 9:0035FI14501F_CV119.59756
        4/9/2018 9:0099PESWFF_CV0.008763643
        4/9/2018 9:0099DEGRHPF_CV0
        4/9/2018 9:0035W11_IHPSTEAMF_CV9.988991792
        4/9/2018 9:00XYZ (Calculation 1)3505FT101F_CV + 35F1821F_CV
        4/9/2018 10:0035FI14501F_CV119.2965316
        4/9/2018 10:003505FT101F_CV136.6248037
        4/9/2018 10:0035W11_IHPSTEAMF_CV10.01061661
        4/9/2018 10:0099PESWFF_CV0.009128429
        4/9/2018 10:0099DEGRHPF_CV0
        4/9/2018 10:0035F1821F_CV5.3100361
        4/9/2018 10:00XYZ (Calculation 1)3505FT101F_CV + 35F1821F_CV
        4/9/2018 11:0035W11_IHPSTEAMF_CV10.00146312
        4/9/2018 11:003505FT101F_CV139.1520708
        4/9/2018 11:0035FI14501F_CV122.0044979