Count and Filter a Table based on today's date

CubaRJ

New Member
Joined
Mar 21, 2022
Messages
29
Office Version
  1. 365
  2. 2019
Platform
  1. 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.
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.
DAX FOmrula.jpg
 

Excel Facts

Format cells as currency
Select range and press Ctrl+Shift+4 to format cells as currency. (Shift 4 is the $ sign).

Forum statistics

Threads
1,223,327
Messages
6,171,484
Members
452,407
Latest member
Broken Calculator

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top