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
I then add a new Measure which checks if the total superable amount for the month is less than $450 and where super has actually been paid.
The measure formula is: =IF( [Superable Amount] <= 450 && [Superable Amount] > 0 && [Paid Super 1] <> 0, "True","False").
When I add this measure to the table I get the following:
You can see that March has been added to the table with no data, but it gets worse if I add the Pay Period ending date:
The Pay Period End Dates then don't sync with the month. Why does this happen and what is wrong with the If measure?
If I take out the If measure, all Period end dates sync correctly with the month.
Would appreciate to understand this.
Anything related to PowerPivot and DAX Formuale
1 post • Page 1 of 1
- Pay3.JPG (111.77 KiB) Viewed 51 times
- Pay2.JPG (44.04 KiB) Viewed 51 times
- Pay1.JPG (45.04 KiB) Viewed 51 times
Who is online
Users browsing this forum: No registered users and 0 guests