Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi Everyone,
I am facing an issue with creating a dax column formula to calculate no of working days based on start and end date of an employee and segregating it according to each month in 2023.
Eg, if A has started working on 01/12/2022 and has an end date of 31/12/2023 - in order to calculate revenue just for 2023 I have added the below formula, to get their revised start date as 01/01/2023.
However, I am not able do the same or those who have joined sometime this year,
for example if X has joined on 8th of august then the data in Alt start date should appear as 01/12/2023 against the dec month in Base date, 01/11/2023 against the novel month in base date and so on. Now the revised start date is 8th august then for the month of August it should appear as the actual start date of august and not the start of the month. like the below marked.
I am facing a challenge to express the below formula in a better way to get the result I want in table number 2 and ultimately a combination of Table 1 and Table 2
ALT start_date = IF(Trial[Start Date] <= Trial[M Alt_Start Date], STARTOFMONTH(Trial[Start od the month]))
Please suggest
User | Count |
---|---|
84 | |
80 | |
72 | |
71 | |
55 |
User | Count |
---|---|
108 | |
106 | |
93 | |
85 | |
67 |