Filter Values Based on Date Range in Matrix (YYYYMM Format)

[danielcastro97]

Hello!

I have a table called fact_pool, which contains a numeric column named "Límite". In this table, there is a start date and an end date defined in the 'YYYYMM' format. I also have my dim_date table with the date_id column in the same format.

With this setup, I am trying to create a matrix where the columns represent months, and the values are the sum of the "Límite" column. The end user will select the years and months to analyze.

What I need to achieve is to verify if the date range defined by the start and end dates in the fact_pool table is included in the range selected by the user. That is, if fact_pool[start_date] is 202407 and fact_pool[end_date] is 202503, and the range selected by the user is between 202401 and 202412, then the "Límite" value should only be displayed for the months 202407, 202408, 202409, 202410, 202411, and 202412.

Thank you!

[Anonymous]

Hi @danielcastro97 ,

Could you please provide example data or sample files here if you have any confused? We could offer you more help if we have information in detail. And what you expect the output to be. There is sensitive data that can be removed in advance. 

How to provide sample data in the Power BI Forum - Microsoft Fabric Community

How to Get Your Question Answered Quickly - Microsoft Fabric Community

Thanks for your understanding. Your time and cooperation are much valued by us. We are looking forward to hearing from you to assist further.

Best regards,

Lucy Chen

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