Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
4 years ago

Help with week selector

I have created a travel/timesheet app and they have to select the week they are travelling or doing a timesheet for

 

michalison_0-1643902487501.png

The week should be 31/01/2022 until 06/02/2022 but they are all out of sync and selecting from the middle of the week

 

I have used this formula    

michalison_1-1643902599585.png

this must be wrong I am teaching myself powerapps so not sure what it should be.  Can anyone help  Thanks

1 Reply

  • lbendlin's avatar
    lbendlin
    Super User
    4 years ago

    This is DAX code, right?  PowerApps uses a different language.

     

    Are you concerned about the sort order ?

     

    My advice would be to add this column further upstream, in Power Query or in your external calendar source. Then you can sort the column by the value column.