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 ...
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 |