Measure Archives

Templates

Dynamic Attendance Sheet Using Power Pivot

February 20, 2023February 20, 2023 PKComments Off

Introduction In today's digital age, managing attendance in schools, colleges, or offices is a time-consuming task. This dynamic attendance sheet can help streamline this process by providing real-time attendance data

Power Pivot

KPI in Power Pivot for dashboard and report

January 15, 2020January 15, 2020 PKComments Off

Key performance indicators (KPIs) are visual measures of performance. Based on a specific calculated field, a KPI is designed to help users quickly evaluate the current value and status of

Power Pivot

SUMX Function in Power Pivot

January 13, 2020January 13, 2020 PKComments Off

In this article, we have explained how to use Measure in Pivot Pivot data model. We have taken the example of SUMX function to calculate the revenue. On the base