Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
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
@Anonymous , Not very clear ,
You can create a measure like
Var _cnt = countrows(Table)
return
if(isblank(_cnt), "No", "Yes")
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
108 | |
105 | |
88 | |
74 | |
66 |
User | Count |
---|---|
124 | |
112 | |
98 | |
81 | |
72 |