Search found 4 matches

by SergeiJ
Tue Jun 23, 2020 12:18 pm
Forum: PowerPivot/DAX
Topic: Adding an "If" measure adds other dates not relevant
Replies: 0
Views: 104

Adding an "If" measure adds other dates not relevant

HI Folks, I've created a power Pivot table from payroll transactions to check if superannuation is calculated only if an employee earns more than $450 per month. The picture below shows one employees data without an IF Dax measure [attachment=2]Pay1.JPG[/attachment] I then add a new Measure which ch...
by SergeiJ
Wed Jun 05, 2019 9:52 am
Forum: PowerPivot/DAX
Topic: HUman Resources PowerPiivot - have to double up on Field from linked tables
Replies: 4
Views: 893

Re: HUman Resources PowerPiivot - have to double up on Field from linked tables

Thanks Phil, I wasn't thinking of putting a measure in since I wasn't adding anything, just wanted the raw information. Putting a measure in - in the first place, allows me to use the Role table without having to add the "lookup" calculated column in the position table. See the following r...
by SergeiJ
Tue Jun 04, 2019 5:48 pm
Forum: PowerPivot/DAX
Topic: HUman Resources PowerPiivot - have to double up on Field from linked tables
Replies: 4
Views: 893

Re: HUman Resources PowerPiivot - have to double up on Field from linked tables

HI PhilC, Well I have updated my data with best practice as best I could and simplified the example for the time being, but I still don't understand why I can't get a straight result with powerpivot. Even with the simpler model, it seems I have to combine data in the tables. My data model now looks ...
by SergeiJ
Tue Jun 04, 2019 12:42 pm
Forum: PowerPivot/DAX
Topic: HUman Resources PowerPiivot - have to double up on Field from linked tables
Replies: 4
Views: 893

HUman Resources PowerPiivot - have to double up on Field from linked tables

I have linked excel to the HR system and have created the following data model HR.JPG I want to get a report out that shows Role ID with the Name of the Position and then the name of each employee that is in that Role. However, everytime I add the employee code to the table, I get a list with all em...

Go to advanced search

cron