Forum Discussion
Solved
Help with COUNT and Filter on Text
Hello, New to BI. I am looking to count September in a month column. Can work out the count part but not the filter, can you help please? Stopped at the below. Absence Rate = CALCULA...
So the answer that i posted before will help you create the table.
To provide more details simply create a table and Drag and Drop the Month as Dimension.
Then create a new measure using the formula that i have put in the previous message.
Add the measure to the table
I have a headcount table with all employees for April, All employees for May etc
And I was creating a column to tell me that there is 2300 employees in April and 2400 in May etc
P.S I have a month table also
So the answer that i posted before will help you create the table.
To provide more details simply create a table and Drag and Drop the Month as Dimension.
Then create a new measure using the formula that i have put in the previous message.
Add the measure to the table