Forum Discussion
Need some help
I'm not sure if I'm in the right section—newbie here—but I have a question regarding Power BI. I have data on maternity leave that currently counts the number of "maternity leave" days per week. For example, if someone takes 5 days of maternity leave, it counts as 5. However, I want to count the maternity leave based on the person, not the number of days. So if one person takes maternity leave in a week, it should count as 1, not 5. Thank you.
Hi,
I do not know how your semantic model looks like, but I tried to create a sample pbix file like below.
Because I do not know how your semantic model looks like, I tried to recreate a sample, and change a little bit.
I changed the weekly-question to the monthly-question, and please check the below picture and the attached pbix file.
Leave count per person: = VAR _t = ADDCOLUMNS ( SUMMARIZE ( leave_date_fact, employee_diemnsion[name], 'calendar'[Month-Year] ), "@metric", 1 ) RETURN SUMX ( _t, [@metric] )
1 Reply
Hi,
I do not know how your semantic model looks like, but I tried to create a sample pbix file like below.
Because I do not know how your semantic model looks like, I tried to recreate a sample, and change a little bit.
I changed the weekly-question to the monthly-question, and please check the below picture and the attached pbix file.
Leave count per person: = VAR _t = ADDCOLUMNS ( SUMMARIZE ( leave_date_fact, employee_diemnsion[name], 'calendar'[Month-Year] ), "@metric", 1 ) RETURN SUMX ( _t, [@metric] )