Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
Hello! I am trying to create a report for Temperature Check in daily for my organization use. A staff need to check in the application twice a day, which is morning and evening. Can we create a measure that count as 1 when a user check in twice a day ?
Example:
Check In Morning | Check In Evening | Count as 1 |
Yes | Yes | 1 |
Yes | No | 0 |
1. you don't need a measure for that as the result is not impacted by any filters - use a calculated column or do it in Power Query
2. your data model is a bit iffy. usually you want to unpivot your data to make it easier to use later.
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.