The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi all,
I have the following table named "Absences", here is a simplified version of it:
employee ID | Key date (EOM) | Sick days (YTD) |
1 | 28. Feb | 20 |
2 | 28. Feb | 3 |
3 | 28. Feb | 2 |
1 | 31. Mrz | 25 |
2 | 31. Mrz | 6 |
3 | 31. Mrz | 4 |
I would like to create a DAX formula to obtain the Monthly value as stated below in my table:
employee ID | Key date (EOM) | Sick days (YTD) | expected column Monthly |
1 | 28. Feb | 20 | 20 |
2 | 28. Feb | 3 | 3 |
3 | 28. Feb | 2 | 2 |
1 | 31. Mrz | 25 | 5 |
2 | 31. Mrz | 6 | 3 |
3 | 31. Mrz | 4 | 2 |
Please note that my data only starts as of February 2023 (no data for Jan 2023), thanks a lot for your help!
Solved! Go to Solution.
Hi @JonathanGiord possible solution, create calculated column; adjust your table name for Sheet1
Did I answer your question? Kudos appreciated / accept solution!
Proud to be a Super User!
Hi @JonathanGiord possible solution, create calculated column; adjust your table name for Sheet1
Did I answer your question? Kudos appreciated / accept solution!
Proud to be a Super User!
User | Count |
---|---|
12 | |
8 | |
6 | |
6 | |
6 |
User | Count |
---|---|
24 | |
14 | |
13 | |
9 | |
7 |