Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers!
Enter the sweepstakes now!Prepping for a Fabric certification exam? Join us for a live prep session with exam experts to learn how to pass the exam. Register now.
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
Check out the May 2025 Power BI update to learn about new features.
Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.
User | Count |
---|---|
74 | |
72 | |
71 | |
50 | |
45 |
User | Count |
---|---|
46 | |
38 | |
29 | |
28 | |
28 |