Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
User | Count |
---|---|
53 | |
28 | |
19 | |
18 | |
14 |
User | Count |
---|---|
92 | |
86 | |
39 | |
23 | |
22 |