Forum Discussion

RafaelAnnibale1's avatar
RafaelAnnibale1
Frequent Visitor
2 years ago
Solved

Help With a Calculated Column

I have this Calculated Column that is needed to register the risk category of each project. It does its job, but not entirely. I need to visualize information based on each project for each quarter. ...
Need Help
Show and Tell
Tutorial Requests
  • RafaelAnnibale1's avatar
    RafaelAnnibale1
    2 years ago

    Total Achievement is a column inside the table: 5 - KPI & Benefit Achievement - All Zones Unpivot
    The ROI V2 is a calculated measure. 
    I'm using the switch because the quarters are not all the same, i've quarter 1,2,3, 4 and each and every one of the quarter has a different values corresponding the roi and total achievement

parry2k's avatar
parry2k
Super User
2 years ago

RafaelAnnibale1 First it is not sure if you are adding a column or a measure and also if all the values you are checking ROI, and Total Achievements are columns or measures.

 

2nd, if all the quarters have the same logic (looks like) why you have a SWITCH to check Quarter value?

RafaelAnnibale1's avatar
RafaelAnnibale1
Frequent Visitor
2 years ago

Total Achievement is a column inside the table: 5 - KPI & Benefit Achievement - All Zones Unpivot
The ROI V2 is a calculated measure. 
I'm using the switch because the quarters are not all the same, i've quarter 1,2,3, 4 and each and every one of the quarter has a different values corresponding the roi and total achievement