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.
Super Usergus_jr what is your expected output based on sample pbix data? Not clear what the exact problem is?
Helper Ihi Parry, thanks again. Take a look at the current month. Usually, specifically in this business, the average daily sales get a pretty uniform behavior month by month. What the example shows us (I think), is that in May, the sales are divided by the total of workdays in that month, instead the six or seven days elapsed until now.
So, look at the "kgs" column, every month is very similar between they. The dayli "kgs" measure, is day by day very regular.