Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
Hi Everyone,
I have some weekly sales available. I will create some data model to recoup the date of each daily sales and also give me the week number.
I would like to have two functions:
- One month-to-date to take the total sales of the months > I know how to do this with the MTD function.
- One function to compute the week-to-date sales. Is there a way to do this?
Thanks!!!
Solved! Go to Solution.
@Tarek78210
Hope this helps: https://radacad.com/week-to-date-calculation-in-power-bi-with-dax
If the post helps please give a thumbs up
If it solves your issue, please accept it as the solution to help the other members find it more quickly.
Tharun
@Tarek78210
Hope this helps: https://radacad.com/week-to-date-calculation-in-power-bi-with-dax
If the post helps please give a thumbs up
If it solves your issue, please accept it as the solution to help the other members find it more quickly.
Tharun
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
| User | Count |
|---|---|
| 9 | |
| 7 | |
| 6 | |
| 6 | |
| 5 |
| User | Count |
|---|---|
| 24 | |
| 21 | |
| 18 | |
| 14 | |
| 13 |