Forum Discussion

Pricey79's avatar
Pricey79
Icon for Helper V rankHelper V
4 years ago

Help with Day by Day entries please

Hello, I was hoping someone could help please. 

 

I have a SharePoint list as my datasource. Using a powerapp every day, a new set of answers should be sent to the SharePoint list against a list of 12 pre populated questions. 

I need to know if these questions got answered on a daily basis, so on a friday evening I should be able to see 

Monday : Yes

Tuesday: Yes

Wednesday : No 

for example

 

And then they reset , ready for the next week

 

I'm really struggling with this, but it feels like it should be fairly simple!?

 

Any help would be greatly appreciated

 

Thank you in advance

Need Help

1 Reply

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

    Hi Pricey79,

     

    Maybe you can try this code to do this.

     

    Measure =
VAR _S =
    SWITCH (
        SELECTEDVALUE ( 'weekday'[week] ),
        "Sun", 0,
        "Mon", 1,
        "Tue", 2,
        "Wed", 3,
        "Thu", 4,
        "Fri", 5,
        6
    )
VAR _Date =
    TODAY ()
        - ( WEEKDAY ( TODAY (), 2 ) - _S )
VAR _filter =
    IF ( _Date > TODAY (), BLANK (), _Date )
RETURN
    IF (
        CALCULATE ( MAX ( 'Table'[if] ), 'Table'[Date] = _filter ) = 1,
        "yes",
        IF ( NOT ( ISBLANK ( _filter ) ), "no" )
    )

     

     

    Pbix in the end you can refer.

    Best Regards

    Community Support Team _ chenwu zhu

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.