Download your certificate of completion after you finish this course: 📄 prag.works/Certificate-Completion-LWTN Class files ✔prag.works/student-files-LWTN-March2023
If tou have a fact table with 2 colums (start datr and end date) you should 1) create a dimension table for calendar 2) create a measure =calculate ( countrows (DimensionCalendar), datesbetween ( DimensionCalendar[Date], fact_table[Start Date], fact_table[End Date]), all (fact table)) This should work.
Download your certificate of completion after you finish this course:
📄 prag.works/Certificate-Completion-LWTN
Class files
✔prag.works/student-files-LWTN-March2023
This is great! Thank you for sharing!
I am looking to ask the number of days between quote and completion of project? Should I use days # in the date table?
If tou have a fact table with 2 colums (start datr and end date) you should
1) create a dimension table for calendar
2) create a measure
=calculate ( countrows (DimensionCalendar), datesbetween ( DimensionCalendar[Date], fact_table[Start Date], fact_table[End Date]), all (fact table))
This should work.
@@nikakalichava8012 thank you for this. This is one of things that had me stumped. I appreciate your help.
@@AlisonPulvermacher No problem.
I must be dumb! I cannot figure out how to add a comment to the chat!
=
Angie married me