Hi all,
I need to count Current week [ 10-April-2022 to 16-04-2022 ] number of dates
See sample below and data set link also attached
Hi @ajisharavind_99 ,
Here the result:
And here the DAX code:
CountPlan5CurrentWeek = CALCULATE ( COUNT ( Table3[Plan 5] ), WEEKNUM ( Table3[Plan 5] ) = WEEKNUM ( TODAY() ) )
CountPlan35CurrentWeek = CALCULATE ( COUNT ( Table3[Plan 35] ), WEEKNUM ( Table3[Plan 35] ) = WEEKNUM ( TODAY() ) )
Let me know if this solves your issue 🙂
/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/
| Did I answer your question❓➡️ Please, mark my post as a solution ✔️ |
| Also happily accepting Kudos 🙂 |
| Feel free to connect with me on LinkedIn! | |
| #proudtobeasuperuser |  |
Hi @ajisharavind_99 ,
Here the result:
And here the DAX code:
CountPlan5CurrentWeek = CALCULATE ( COUNT ( Table3[Plan 5] ), WEEKNUM ( Table3[Plan 5] ) = WEEKNUM ( TODAY() ) )
CountPlan35CurrentWeek = CALCULATE ( COUNT ( Table3[Plan 35] ), WEEKNUM ( Table3[Plan 35] ) = WEEKNUM ( TODAY() ) )
Let me know if this solves your issue 🙂
/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/
| Did I answer your question❓➡️ Please, mark my post as a solution ✔️ |
| Also happily accepting Kudos 🙂 |
| Feel free to connect with me on LinkedIn! | |
| #proudtobeasuperuser | |
Helpful resources
Power BI Dataviz World Championships
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
Power BI Monthly Update - December 2025
Check out the December 2025 Power BI Holiday Recap!
FabCon Atlanta 2026
Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
