dax
3 Topics
Count of number of times value is present and create a custom column
In PowerQuery I want to add a custom column that evaluates how often a value exists and create a custom column based on the value For example, new custom column(No of Rows) should be created based on how many times value exist in Column1 and if it is greater than 1 it should display as Yes or No in the column Result Column The below screen shot is what I'm trying to create I dont want to create any group/summarized tableSolved2.2KViews0likes3Comments
Remove rolling total/cumulative effect from a sequence of amounts
Hey there, I want to remove rolling total/cumulative effect from a sequence of amounts? My data looks like this Date Account Region Amount 31/01/2016 n123456 US 10 31/03/2016 n123456 US 25 31/08/2016 n123456 US 70 30/09/2016 n123456 US 71 29/02/2016 x987654 Canada 50 31/03/2016 x987654 Canada 305 30/04/2016 x987654 Canada 1000 30/09/2016 x987654 Canada 5000 What I would like to calculate is this: Date Account Region Amount 31/01/2016 n123456 US 10 31/03/2016 n123456 US 15 31/08/2016 n123456 US 45 30/09/2016 n123456 US 1 29/02/2016 x987654 Canada 50 31/03/2016 x987654 Canada 255 30/04/2016 x987654 Canada 695 30/09/2016 x987654 Canada 4000 Is there a nice way for me to achieve this using DAX/Power Query ? Thanks amitchandak Pragati11Solved933Views0likes2CommentsHow 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
