Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi there.
I am new to PowerBi and stuck on a DAX formula.
Basically in my table, I have 3 columns that refer to 3 different answers from an individual in a survey. I want to create a 4th column to tell me how many of the other 3 columns they put in an answer for i.e. if they answer 2 out of the 3 questions, the 4th column will give me a 2 and so on. This is based on one individual row. See example below with the column in bold is what I need.
Name | Start | End | 3month | ResponseRate |
Joe | 1 | 4 | 5 | 3 |
Mary | 4 | 0 | 2 |
I have got it to work using :
Solved! Go to Solution.
@Anonymous , a new column in dax
if(isblank([column1]),0,1) + if(isblank([column2]),0,1)+if(isblank([column3]),0,1)
@Anonymous , a new column in dax
if(isblank([column1]),0,1) + if(isblank([column2]),0,1)+if(isblank([column3]),0,1)
Thank you sooooo much!!!:D
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
85 | |
84 | |
65 | |
62 | |
55 |
User | Count |
---|---|
171 | |
109 | |
105 | |
73 | |
71 |