Forum Discussion
Syndicate_Admin
Administrator
AdministratorCalculate Sales by Useful Days
Hi, I'm working on a report and would like to calculate sales per working day.
For example, I have a date filter from 01/10/2023 to 10/10/2023, which gives me 8 business days, I would like to know what the sales are in the 8 business days of September 23.
Thank you.
1 Reply
- amitchandak
Super User
Syndicate_Admin , refer of one of these can help
Traveling Across Workdays - What is next/previous Working day
https://community.powerbi.com/t5/Community-Blog/Travelling-Across-Workdays-Decoding-Date-and-Calendar-4-5-Power/ba-p/1187766Power BI - Business day with and without using DAX Function NETWORKDAYS: https://www.youtube.com/watch?v=Qs03ZZXXE_c
https://medium.com/@amitchandak/power-bi-dax-function-networkdays-5c8e4aca38c
