Forum Discussion
Helper IBusiness Days Elapsed for each month.
Hi gus_jr ,
You can generate your required output in many ways and one example is as follows:
Create a calendar table which identifies weekdays and weekends. (Please note that this is not identifying national holidays and bank holidays).
You can create a measure of the countrows of the calendar table, keepfiltering weekdays and days on and before today.
I attach the pbix file as an example.
Helper IThank a lot for your support, it was really usefull, but i have to say, that my doubt wasnt pretty clear. What i need is a measure, called Average Daily, that calculate a divide bewtween, for example, the entire sales volume and the days. If it s a closed month, divide for the total workdays, and if its a curren month, divide for the elapsed days of the acutal month. Here i share a table, maybe help you to understand this better, and a little bit of the dashboard that i been working.
Super UserHi,
Share some data to work with.
- gus_jr
Hi, Ashish, thank you for answer. I shared after that first post, a table and screenshoot of that part of the dashboards, on the messages belows.
- Ashish_Mathur
You are welcome. That shows the expected result. It is not the raw data.
- gus_jr
thank you, again. Here I share you a PBX file, that try to show the calculate that I looking for. If you realize that in the current month, has been pass 6 days, and I need that the current month has been divide for that 6 days. In the sample that I shared, the sum of tons is divide por the total of workdays of this current month. Thank you, for try help me.