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...
Need Help
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.