79631856

Date: 2025-05-21 11:19:19
Score: 0.5
Natty:
Report link

I found the following path to make what I was looking forward to.

First: I format and create a measure with the current month like this -->

CurrentMonth = FORMAT(TODAY(),"YYYY.MM")

Then, I change the format to text of this measure and the one that I'm going to compare to. Once the measure and the column is in TEXT format. I create an IF statemente like this -->

Current_Month = IF('Fechas: Mes/Trimestre'[YearMonth] = [CurrentMonth], "Actual Month",'Fechas: Mes/Trimestre'[YearMonth])

And with this I finally create this filter

enter image description here

So, this is what I was looking to create :)

Reasons:
  • Long answer (-0.5):
  • Has code block (-0.5):
  • Self-answer (0.5):
  • Low reputation (1):
Posted by: Francisco Guiroy