Count values ​​before and after today's date in month

[Raul_Cristobal]

Hello, I want to count the values ​​that exist before and after today's date during the month.

For example, in the table there are 84 values ​​in the month of December. Today is 5/12/2022 (today()) therefore 2 measurements should be returned.
- There are 6 values ​​(rows) before 12/5/2022 (today())
- There are 77 values ​​(rows) after 12/5/2022 (today()) not including the same day.

And so on for the months in the filter.

[Raul_Cristobal]

Hello, I want to count the values ​​that exist before and after today's date during the month.

For example, in the table there are 84 values ​​in the month of December. Today is 5/12/2022 (today()) therefore 2 measurements should be returned.
- There are 6 values ​​(rows) before 12/5/2022 (today())
- There are 77 values ​​(rows) after 12/5/2022 (today()) not including the same day.

And so on for the months in the filter.

[Manoj_Nair · Accepted solution]

@Raul_Cristobal - Try this solution and let me know if this meets your requirement. Many Thanks

After Today = COUNTX(FILTER(Maintenance,Maintenance[DIA] > DAY(TODAY())), Maintenance[MES])

Before Today = COUNTX(FILTER(Maintenance,Maintenance[DIA] < DAY(TODAY())), Maintenance[MES])

[Raul_Cristobal]

Thanks!!!!

[Manoj_Nair]

@Raul_Cristobal, saw a similar post from you yesterday, was that similar or different. Post link https://community.powerbi.com/t5/Power-Query/Count-values-before-and-after-today-s-date-in-month/m-p.... Pls confirm. Thanks

[v-yinliw-msft]

Hi @Raul_Cristobal ,

You can try this method:

Sample data:

New two measures:

BeforeToday = CALCULATE(COUNTROWS('Table'),FILTER('Table', 'Table'[Date] < TODAY())) 

AfterToday = CALCULATE(COUNTROWS('Table'),FILTER('Table', 'Table'[Date] > TODAY()))

The result is:

Hope this helps you.

Here is my PBIX file.

Best Regards,

Community Support Team _Yinliw

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.