Need MTD, QTD & YTD Data as per creteria attached for attendance Report

Hi hmalhotra,

I would use the Extneded Date table. It will have all the parameters you need in order to do time intelligence. I added it for you and created a measure called “Gender Count” on page 2 so you can see how it works.

Extended Date Table (Power Query M function) - Power Query / M Code Showcase - Enterprise DNA Forum

Let us know if you have any questions.

Greystar India Attendance Report - Reviewed.pbix (292.7 KB)

1 Like