ifelse
1 Topic
How to use DAX/Power Query to perform calculation with multiple if else condition
Hi, I have the following table in Power BI, how do I generate the last column 'Average_Awareness_Percentage' in Power Query/DAX. I have described the intended formula for column 'Average_Awareness_Percentage'. Not sure if this can be achieved in Power Query but I have no experience using DAX either. Any help from the community to get me started with this would be helpful! Staff ID Department Year Standards QuestionNo Question Response_No Response Average_Awareness_Percentage 203382 IT 2020 IFRS15 1 Are you aware of the IFRS15 standards? 1_A Yes 1 - (Total Count Response is '1_B'/Total Count of Department is 'Accountant' where QuestionNo is '1' ) 205282 Accountant 2020 IFRS15 1 Are you aware of the IFRS15 standards? 1_B No 1 - (Total Count Response is '1_B'/Total Count of Department is 'Accountant' where QuestionNo is '1' ) 205928 Accountant 2020 IFRS15 1 Are you aware of the IFRS15 standards? 1_A Yes 1 - (Total Count Response is '1_B'/Total Count of Department is 'Accountant' where QuestionNo is '1' ) 112959 Accountant 2020 IFRS15 2 Which of the following is an exception for application of IFRS 15? 2_C Insurance (Total Count Response is '2A' + Total Count Response is '2_B') / Total Count of Department is 'Accountant' where QuestionNo is '2' 112966 Accountant 2020 IFRS15 2 Which of the following is an exception for application of IFRS 15? 2_A Music Subscription (Total Count Response is '2A' + Total Count Response is '2_B') / Total Count of Department is 'Accountant' where QuestionNo is '2' 123459 Accountant 2020 IFRS15 2 Which of the following is an exception for application of IFRS 15? 2_B Mobile Service (Total Count Response is '2A' + Total Count Response is '2_B') / Total Count of Department is 'Accountant' where QuestionNo is '2' 205262 Accountant 2020 IFRS15 2 Which of the following is an exception for application of IFRS 15? 2_D Lease (Total Count Response is '2A' + Total Count Response is '2_B') / Total Count of Department is 'Accountant' where QuestionNo is '2' 205982 IT 2020 IFRS15 2 Which of the following is an exception for application of IFRS 15? 2_E All of above (Total Count Response is '2A' + Total Count Response is '2_B') / Total Count of Department is 'Accountant' where QuestionNo is '2' 239282 Accountant 2020 IFRS15 2 Which of the following is an exception for application of IFRS 15? 2_E All of above (Total Count Response is '2A' + Total Count Response is '2_B') / Total Count of Department is 'Accountant' where QuestionNo is '2' 177959 Accountant 2020 IFRS16 3 Are you aware of the IFRS16 standards? 3_A No Total Count Response is '3_B'/Total Count of Department where QuestionNo is '3' 192902 IT 2020 IFRS16 3 Are you aware of the IFRS16 standards? 3_A No Total Count Response is '3_B'/Total Count of Department where QuestionNo is '3' 205208 Accountant 2020 IFRS16 3 Are you aware of the IFRS16 standards? 3_B Yes Total Count Response is '3_B'/Total Count of Department where QuestionNo is '3' 352959 Accountant 2020 IFRS16 3 Are you aware of the IFRS16 standards? 3_B Yes Total Count Response is '3_B'/Total Count of Department where QuestionNo is '3' 352959 Accountant 2020 IFRS16 4 Which of the following shall a lessee recognise at commencement? 4_A Right-of-use (Total Count Response is '4_A' + Total Count Response is '4_B')/Total Count Response_No is '3_B' 263935 Accountant 2020 IFRS16 4 Which of the following shall a lessee recognise at commencement? 4_B Lease-liability (Total Count Response is '4_A' + Total Count Response is '4_B')/Total Count Response_No is '3_B' 653964 Accountant 2020 IFRS16 4 Which of the following shall a lessee recognise at commencement? 4_E Uncertain (Total Count Response is '4_A' + Total Count Response is '4_B')/Total Count Response_No is '3_B' 205282 Accountant 2020 IFRS16 4 Which of the following shall a lessee recognise at commencement? 4_E Uncertain (Total Count Response is '4_A' + Total Count Response is '4_B')/Total Count Response_No is '3_B'Solved1KViews0likes3Comments