Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
I can get working days between two dates using networkdays functions but how do I add x number of working days to a date that has an in active relationship to date table and fact table? The relation is 1 to many.
Can you please share the relevant columnnames and your current measure. So i do not have to build it for me own und perhaps wrong. Please no screeshot. Use the existing table function of the forum.
Proud to be a Super User!
You calculate in your date table the networkdays and want to add the result to the date column in your facttable with a inactive relationsship?
Proud to be a Super User!
Hi, @andhiii079845 yes that is correct, table of holidays exist that has a lookup flag colum in calendar table and calendar table has rank column.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.
| User | Count |
|---|---|
| 8 | |
| 7 | |
| 6 | |
| 5 | |
| 4 |
| User | Count |
|---|---|
| 25 | |
| 11 | |
| 8 | |
| 8 | |
| 8 |