Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |