Forum Discussion
Solved
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 ...
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] )
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] )