Forum Discussion

yatheeshaworks's avatar
yatheeshaworks
Frequent Visitor
4 years ago
Solved

starting week day along with time in dax function

how to get starting week day along with time in dax function

Need Help
  • v-luwang-msft's avatar
    v-luwang-msft
    4 years ago

    Hi yatheeshaworks ,

    Test the below:

    Table = CALENDAR("2022,1,1","2022,12,31")
    Table = CALENDAR("START_DT","End_dt")

     

    You can use the following statement to exclude days off and take only weekdays.

     

    Did I answer your question? Mark my post as a solution!


    Best Regards

    Lucien

     

3 Replies

  • AUDISU's avatar
    AUDISU
    Icon for Resolver III rankResolver III
    4 years ago

    HI,

     

    Could you please show me an example of data you required?

    Thanks

  • v-luwang-msft's avatar
    v-luwang-msft
    Icon for Community Support rankCommunity Support
    4 years ago

    Hi yatheeshaworks ,

    Test the below:

    Table = CALENDAR("2022,1,1","2022,12,31")
    Table = CALENDAR("START_DT","End_dt")

     

    You can use the following statement to exclude days off and take only weekdays.

     

    Did I answer your question? Mark my post as a solution!


    Best Regards

    Lucien