Help with Day by Day entries please

[Pricey79]

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

[v-chenwuz-msft]

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.