User Profile
arcall
Frequent Visitor
Joined 7 years ago
User Widgets
Contributions
Re: Total Headcount progression on current year
Hi Lin, I am not getting the visual I am expecting. First, I just want to clarify about the date tag. I have a date table with a relationship to the databable (Called "HR Data"). I presume the date tag is under that date table and is a column ? Is the relationship between the date and HR Data will confuse this measure ? Here is the DAX command for tag. tag = IF(YEAR('Date'[Date])=YEAR(TODAY())&&MONTH('Date'[Date])<=MONTH(TODAY()),"y","n") In the page date filter, do I select all years ? Here is my crossjoin table : Table = FILTER(CROSSJOIN('Date','HR Data'),'Date'[tag]="y"&&'HR Data'[Active]="Yes"&&'Date'[Date]>='HR Data'[Hire Date]&&'Date'[Date]<='HR Data'[Termination/Release Date]) I have a graphic visual with "Shared Axis" with Month from Date table amd Total HeadCount from the following measure. Total Headcount = CALCULATE(COUNTA('HR Data'[Name])) Here is what i've got. I should have a cumulative amount and it should stop at April. What am I doing wrong ? ThanksTotal Headcount progression on current year
Hello All, I am trying to achieve a total headcount visual for the following. I have a table with the following columns. Name of emp, hire date, termination date, Active(y or n), Class (Production or Support/...) The hire date started many years ago. I want to create the following visual that will show the overall headcount by month, but only show the current year up to the current month. Here is what i want to reproduce. Your help is appreciated. Thanksspread revenue across a period based on start and end date in visual matrix
Hello All, I need to create a matrix that will show the revenue spread in month column. I manage do do it in Excel but I cannot find a way to do it in PBI. I have an revenue column, a start date and end date. I need to create a visual like this. Can someone give me some direction on how to do it ? Thanks
