Hi,
I am able to filter data for this year, this month using below query:
Pulls= IF(YEAR(Encomp[Credit_Pull_Date]) = YEAR(TODAY()) && MONTH(Encom[Credit_Pull_Date]) = MONTH(TODAY()),1,0)
But now I want to filter data for this year till today. I tried below query but is is not working:
Current_Month_CreditPull = IF(YEAR(Encomp[Credit_Pull_Date]) = YEAR(TODAY()) && MONTH(Encomp[Credit_Pull_Date]) = MONTH(TODAY() && (Encomp[Credit_Pull_Date] <= TODAY())),1,0)
Please suggest.
Shikha
Hi @Anonymous
Create two measures
Measure = TODAY() Measure 2 = IF ( YEAR ( MAX ( [date] ) ) = YEAR ( [Measure] ) && MONTH ( MAX ( [date] ) ) = MONTH ( [Measure] ) && MAX ( [date] ) <= [Measure], 1, 0 )
Best Regards
Maggie
Maggie, Thanks a ton for your reply.
I tried your solution but it is not working :(.
Hi @Anonymous
What's wrong with it?
Could you share some screenshot?
Best Regards
Maggie