CubaRJ
New Member
- Joined
- Mar 21, 2022
- Messages
- 20
- Office Version
- 365
- 2019
- Platform
- Windows
Hi, I am a noob on PowerBI and working my first project and just hit a wall 
My dataset is huge due to the need to plan activities ahead, so the headers will be name, role and installation plus the dates between 01DEC2022 to 01JAN2025. My conundrum is that I need a measure to return the number of persons on determined status: Sick Leave (Code M), Vacation (Code V), Parental Leave (Code GPL).
This is a Excel formula that return the cell and then I count cuont based on their values.
The Row-4 is because the table starts 4 rows below.
Any idea of the DAX formulas to get that?
Here is an example of my header.
My dataset is huge due to the need to plan activities ahead, so the headers will be name, role and installation plus the dates between 01DEC2022 to 01JAN2025. My conundrum is that I need a measure to return the number of persons on determined status: Sick Leave (Code M), Vacation (Code V), Parental Leave (Code GPL).
This is a Excel formula that return the cell and then I count cuont based on their values.
Excel Formula:
=INDEX(PlanningTable[#All],(ROW())-4,MATCH(dteToday,PlanningTable[#Headers],0))The Row-4 is because the table starts 4 rows below.
Any idea of the DAX formulas to get that?
Here is an example of my header.
