Help displaying new record on SharePoint

[Anonymous]

Hi,

Hoping if someone could help me with this issue.

I have a SharePoint list which is connected to the PowerBI. A new record is created using PowerApps daily recording a checklist being completed, I would like to show in PowerBI a list of days with a Yes/No if that checklist was completed on that day.

This is something I'm looking for.

Kind regards, 

Cevin 

[Anonymous]

Hi,

Thank you for your reply.

I'm fairly new to PowerBI but I'm not too sure what you mean when you say to count rows in a table. I've got a SharePoint list that I can use as the table but I'm not sure if that's the right approach. Also with the if statement, I'm not sure if that measure would tell me specifically what days are blank or not. I want to count the individual records not rows. 

Kind regards, 

Cevin

[amitchandak]

@Anonymous , Not very clear ,

You can create a measure like

Var _cnt = countrows(Table)

return

if(isblank(_cnt), "No", "Yes")