Calculation Based on Values in PowerBI

[pgnilesh]

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_Date	Tag_Name	Tag_Value
4/9/18 9:00 AM	3505FT101F_CV	136.624876
4/9/18 9:00 AM	35F1821F_CV	5.29965
4/9/18 9:00 AM	35FI14501F_CV	119.59756
4/9/18 9:00 AM	99PESWFF_CV	0.008763643
4/9/18 9:00 AM	99DEGRHPF_CV	0
4/9/18 9:00 AM	35W11_IHPSTEAMF_CV	9.988991792
4/9/18 10:00 AM	35FI14501F_CV	119.2965316
4/9/18 10:00 AM	3505FT101F_CV	136.6248037
4/9/18 10:00 AM	35W11_IHPSTEAMF_CV	10.01061661
4/9/18 10:00 AM	99PESWFF_CV	0.009128429
4/9/18 10:00 AM	99DEGRHPF_CV	0
4/9/18 10:00 AM	35F1821F_CV	5.3100361
4/9/18 11:00 AM	35W11_IHPSTEAMF_CV	10.00146312
4/9/18 11:00 AM	3505FT101F_CV	139.1520708
4/9/18 11:00 AM	35FI14501F_CV	122.0044979

Thanks,

Nilesh

[vanessafvg]

@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]

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]

@vanessafvg,

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

Tag_Date	Tag_Name	Tag_Value
4/9/2018 9:00	3505FT101F_CV	136.624876
4/9/2018 9:00	35F1821F_CV	5.29965
4/9/2018 9:00	35FI14501F_CV	119.59756
4/9/2018 9:00	99PESWFF_CV	0.008763643
4/9/2018 9:00	99DEGRHPF_CV	0
4/9/2018 9:00	35W11_IHPSTEAMF_CV	9.988991792
4/9/2018 9:00	XYZ (Calculation 1)	3505FT101F_CV + 35F1821F_CV
4/9/2018 10:00	35FI14501F_CV	119.2965316
4/9/2018 10:00	3505FT101F_CV	136.6248037
4/9/2018 10:00	35W11_IHPSTEAMF_CV	10.01061661
4/9/2018 10:00	99PESWFF_CV	0.009128429
4/9/2018 10:00	99DEGRHPF_CV	0
4/9/2018 10:00	35F1821F_CV	5.3100361
4/9/2018 10:00	XYZ (Calculation 1)	3505FT101F_CV + 35F1821F_CV
4/9/2018 11:00	35W11_IHPSTEAMF_CV	10.00146312
4/9/2018 11:00	3505FT101F_CV	139.1520708
4/9/2018 11:00	35FI14501F_CV	122.0044979