Forum Discussion
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 ...
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?
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
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