IF with multiple condition (more than 3) + DAX formula help needed
Hi Masters, I am pretty new in DAX as well as in Power BI. Please see below snapshots : Basically I am trying to mark/tag my projects with specific words based on their approval statuses. I have 3 types of approvals and if all have "Yes" I would like to write and tag that project as "F-R-W" whcih stands for "Finance - Risk - Workstream". I am able to do this in excel table where I have one table. However now I am trying to do this in database where I have many tables with relationships. It is not only question around multiple AND conditon with IF, it is also how I can do this in database where I have multiple tables . Please check snapshots and i hope you will understand what I am trying to do. Excel formula that I used to use: In DAX - what I am trying to do Expected DAX outcome: Regards, Akito
DAX measure with multiple IFs
Hello, Please can you help me to write this DAX measure in Power BI? I have 5 columns with multiple combinations (A - E) and F column which summarize the columns A - E. I need to obtain the result from column "RESULT" and I don't know what formula should I use. Thank you for your support.
New Conditional Column Calculation based on (non-value) other column entry
Hi, I'm relatively new to PBI and I wanted to create a column showing the 'Bonus' amount (the new 'outcome' column) but based on a calculation of either ("Sales Rev" x "Multiplier") or ("Sales+Referrals Rev" x "Multiplier)". So for example, if the entry in Column B ("Level") = 'Junior', the multiply column C ("Sales Rev" which is itself a sum of certain columns) by the column E ("Multiplier", which is itself a calculated field). But if the entry in Column B("Level") = 'Exec', the multiply column D ("Sales Rev + Referrals" which is itself a sum of different columns) by the column E ("Multiplier"). Hope that makes sense. I'm working in the Transform Data table at the moment, and would appreciate any guidance! I've copied the data back into excel to illustrate what i'm trying to show... Much appreciated, Bx
Daily Average Number of Cases Open- Community Services
Dear Members/super contributors, In community services we have to report on daily average number of clients in the care program per month. This is calculated under following conditions: 1. If the client was in care program prior to start of the month and stayed in the care till the end- then we count as number of days in the month. 2. if the client joined the care program within the month then we take datediff between the date of joining and the end of the month date. 3. if the Client left the program within the month under consideration then we do the datediff between the start of the that month and the day they left the program. We add all these numbers and divide them by the number of days in the month to calculate daily average. If someone can help me with syntax of multiple if/ any other function and multiple datediff's or any other way to approach it. My data looks like this and the last column is the intended solution Thanks in advance
