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.
I'm trying to calculate Sales Per Week. The problem i'm having is the Partial weeks since im using a Regular Calendar Year.
Since there are only 2 days in week 27 for June, I was trying to get the June month to use 4.28 as the denominator instead of 5.
I've been wracking my brain on how to calculate this.
My Data is as follows.
Solved! Go to Solution.
@Tuan , You can try divide by distinct count of date
divide(sum(Table[New Sales]),distinctcount(Table[Sales Date]))
Prefer to Date table and have Week there
@Tuan , You can try divide by distinct count of date
divide(sum(Table[New Sales]),distinctcount(Table[Sales Date]))
Prefer to Date table and have Week there
Assuming you have a Date table, you can just use
Weeks = COUNTROWS('Date'[Date])/7
If you don't have a Date table, and potentially have no rows on some dates, you could use
Weeks = (DATEDIFF(MIN(Table[Date]), MAX(Table[Date]), DAY)+1)/7
If this works for you, please mark it as the solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
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 |
---|---|
110 | |
95 | |
76 | |
65 | |
51 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |