Adding an "If" measure adds other dates not relevant

Anything related to PowerPivot and DAX Formuale
SergeiJ
Posts: 4
Joined: Tue Jun 04, 2019 12:13 pm

Adding an "If" measure adds other dates not relevant

Postby SergeiJ » Tue Jun 23, 2020 12:18 pm

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 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:
[attachment=1]Pay2.JPG[/attachment]

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:
[attachment=0]Pay3.JPG[/attachment]

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.
Attachments
Pay3.JPG
Pay3.JPG (111.77 KiB) Viewed 101 times
Pay2.JPG
Pay2.JPG (44.04 KiB) Viewed 101 times
Pay1.JPG
Pay1.JPG (45.04 KiB) Viewed 101 times

Return to “PowerPivot/DAX”

Who is online

Users browsing this forum: No registered users and 3 guests

cron