Forum Discussion
Advocate IVDATESWTD is not working as expected
Hi All,
I am working on one project where i was able to test DATESYTD, DATESMTD, DATESQTD.
But recently there was one function - DATESWTD. This is not working as expected.
Attached Screenshots.
Please assist in this.
Thanks,
Santhosh
hello santhoshkj
seems because 'DateMaster'[Date] is not fulfill the requirement of using DATESWTD.
here is the requirement of using DATESWTD
Hope this will help.
Thank you.
5 Replies
IrwanSuper User
hello santhoshkj
seems because 'DateMaster'[Date] is not fulfill the requirement of using DATESWTD.
here is the requirement of using DATESWTD
Hope this will help.
Thank you.
ryan_mayupls make sure Date is a proper calendar table and marked as a Date Table
- danextian
Hi santhoshkj
Please make sure your dates table has a complete set of dates (no skips) and has been marked as such.
- v-prasare
Community Support
Hi santhoshkj,
We would like to confirm if our community members answer resolves your query or if you need further help. If you still have any questions or need more support, please feel free to let us know. We are happy to help you.
Thank you for your patience and look forward to hearing from you.
Best Regards,
Prashanth Are
MS Fabric community support - v-prasare
Hi @santhoshkj,
We would like to confirm if our community members answer resolves your query or if you need further help. If you still have any questions or need more support, please feel free to let us know. We are happy to help you.
Thank you for your patience and look forward to hearing from you.
Best Regards,
Prashanth Are
MS Fabric community support
