Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hello dear members ,
I have a table called planning that contain the absence details of my employees .
I wanted to create a calculated column that contain the absence details of my employee but in case an employee have 2 absence reasons in the same day i want the colmumn to have the value Multi .
I did some research and i notice that i might be able to do that with all expect funtion , but here i have 2 condition (same ID and same Day)
Here is a small sample ! what im trying to acheive (Created column in green 😞
thanks in advance all
Solved! Go to Solution.
Hi,
with Dax you can add a calculate column
Hello ,
@Bifinity_75, @serpiva64 thanks for your answers .
your both solution are working but there is only 1 condition that have issue , is that when the employee is absent the same day with the same reason it shouldnt show multi since it's the same reason of absence .
Hi,
try this
@serpiva64 , unfortunately the query dont want to charge . it keep loading only , do you think it's related to the query performance ?
Hi,
Can you post your calculated column?
Hi @Rayzo92 , try this calculate column:
Created Column = IF(
CALCULATE(COUNTROWS('Table'),ALLEXCEPT('Table','Table'[id],'Table'[day]))>1,
"Multiple",'Table'[reason of absence])
Best regards
Hi,
with Dax you can add a calculate column
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
73 | |
72 | |
38 | |
30 | |
26 |
User | Count |
---|---|
99 | |
87 | |
45 | |
43 | |
35 |