Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
User | Count |
---|---|
139 | |
113 | |
103 | |
77 | |
63 |
User | Count |
---|---|
135 | |
126 | |
110 | |
70 | |
61 |