We're giving away 30 tickets for FREE! Share your story, your vision, or your hustle and tell us why YOU deserve a ticket.
Apply nowWin a FREE 3 Day Ticket to FabCon Vienna. Apply now
Dear Power BI Experts,
When i am using the following function the actual salary does not picked up since the appointment date is in the month of any date therefore the acutal salary of the generated payroll calcuated accordingly the number of days paid in the month. I want the actual Salary on which the employee hired
First Gross Salary = Calculate ( Sum(Payroll Sheet [Gross Salary]), Firstdate( Payroll[month])
Please suggest a dax formula to create a column so that i am able to find out the actual salary on which he/she has hired at..
Regards,
Saad Hanif
User | Count |
---|---|
13 | |
12 | |
7 | |
7 | |
6 |
User | Count |
---|---|
26 | |
20 | |
13 | |
11 | |
5 |