User Profile
Aj72
Frequent Visitor
Joined 3 years ago
User Widgets
Contributions
Re: Date Slicer issue
The content below is a snapshot - in col.3 there are both dates and null values. I've managed to show a count of null values but it shows as the full amount. I want to be able to filter the date slicer to show dates prior to a particular date of choice by the user which also shows how many null values there are by Area.Date Slicer issue
Hi I have a dashboard which includes office locations, number of Live records (Count (distinct), Number of Blank Reviews based on null entries within date column - Measure1 = COUNTROWS ( 'Sheet1' ) - COUNTROWS ( FILTER ( 'Sheet1', Sheet1[Next LM Review Date] <> BLANK () ) ) , and a date slicer. When I move the date slicer to a particular reporting date, the Live records figure obviously changes but the Number of blanks in the date column doesn't - is there a way to have the date slicer affect the number of blank reviews based on null entries? Relative newby so please be gentle 😉Re: Comparison of monthly reports
Thank you Neeko! 1. In any way possible - but preferably a table of just those that have changed from one month to the next. 2. As it's an audit tracker of user's roles, I need to know who, what, when a role has changed. There's 15 columns and over 20,000 rows in each monthly report. 3. Yes. All users will by default have EMPLOYEE, they could have any number of other roles specific to their job. I'm unable to share any of the data due to Org's security. User Name Person Number Full Name Assignment Status Type Job Name Role Name Role Added Date Role End Date Group [email protected] 000001 Smith, Alan Active Employee Org Employee 01/01/2020 South West [email protected] 000001 Smith, Alan Inactive HR Systems Org HR Sys 03/03/2019 02/02/2021 South West [email protected] 000001 Smith, Alan Active HOBC Org HOBC 04/04/2020 South West [email protected] 000002 Jones, Bob Inactive HRAM Org HRAM 01/05/2019 10/12/2021 North East [email protected] 000002 Jones, Bob Active ABM Org ABM 01/05/2019 North East [email protected] 000002 Jones, Bob Active Employee Org Employee 01/05/2019 North East If the above was month 1, and month 2 showed any details in any of the last 6 columns as being different, then it would pull the complete row into a new table say "Monthly Changes". I hope this makes sense!Comparison of monthly reports
I have a monthly report run from Oracle HCM. I want to compare one month's data to another, but not to duplicate each time. In effect - month 2 compared to month 1; mth 3 - mth 2; mth 4 - mth 3 etc. The tables I have so far... The BASE DATA > ROLE NAME is what I'm primarily looking at - to see what Oracle HR User Roles each individual have. This could be from 1 to maybe 20 roles per person - and I need to extract and highlight those people who have changed one or more of their roles from the previous month. I've hit a dead-end and can't see a way passed - relatively new to PBi
