Count working days of a month only until today

[Anonymous]

Dear Power BI Profs,
I am relatively new to Power BI and am currently facing a tough problem that I cannot solve on my own.

My boss wants me to calculate the expected number of billed orders for each month.

Example:
Today = 06/27/2022
Billed orders: 2000
Total working days June: 21
Working days up to and including today (June): 19 (this is my problem)
Calculated: 2000/19*21

I already have in Power BI:
- Data table with the orders
- Calendar table with date, weekday number, holidays
- Additional table only with the date of the working days (without weekends, without holidays)

Measure for working days in June I have already made:

 Countx(Filter(Workingdays;Workingdays[Month]="June");Workingdays[Day]))

I am now only missing a formula with which I calculate the working days for the respective month until today.

Very dear greetings from Germany

Bianca

[ribisht17]

@Anonymous 

Please check the working file here Parameter - Google Drive

1. Set the missing relationship

2. Make use of Parameters to pick the day, for example, you need to pick 27.

If we directly use Tag there to filter 27, it will give us the count on that day only

Regards,

Ritesh

Mark my post as a solution if it helped you| Munde and Kudis (Ladies and Gentlemen) I like your Kudos!! !!
My YT Channel Dancing With Data !! Connect on Linkedin !!Power BI for Tableau Users 

[Anonymous]

Dear Ribisht17,

thank you very much.

but how can I do now the Projection / Forecast to 21 working Days in June.

And why powerbi calculate numbers on 31. June?

June only have 30 Days 😄

[ribisht17]

or paste-like this , I just did copy paste

Row ID	Order Priority	Discount	Unit Price	Shipping Cost	Customer ID	Ship Mode	Customer Segment
18606	Not Specified	0.01	2.88	0.5	2	Regular Air	Corporate
20847	High	0.01	2.84	0.93	3	Express Air	Corporate
23086	Not Specified	0.03	6.68	6.15	3	Express Air	Corporate
23087	Not Specified	0.01	5.68	3.6	3	Regular Air	Corporate
23088	Not Specified	0	205.99	2.5	3	Express Air	Corporate
23597	Medium	0.09	55.48	14.3	3	Express Air	Corporate
25549	Low	0.08	120.97	26.3	3	Delivery Truck	Corporate
20228	Not Specified	0.02	500.98	26	5	Delivery Truck	Home Office
19483	Low	0.08	6.48	6.81	5	Regular Air	Home Office
24782	High	0.01	90.24	0.99	6	Regular Air	Home Office
24563	Critical	0.07	6.48	6.6	6	Regular Air	Home Office

[ribisht17]

Not feasible to do this without having access to data, I can just give an idea without data

[Anonymous]

How can I give you access to data?

[ribisht17]

You can drop your sample PBIX file to dropbox 

[Anonymous]

here it is https://www.dropbox.com/s/c3m3ofrqdolnqhg/Auftr%C3%A4ge%20in%20Abrechnung.pbix?dl=0

I am so really thankful for every help.

It isn't my first report in PowerBI but the hardest one.

[ribisht17]

@Anonymous 

You need to have this filter 

Month-Day Less than Today = DAY(TODAY()) >= day( 'Calendar Table'[Date])

Regards,

Ritesh

Mark my post as a solution if it helped you| Munde and Kudis (Ladies and Gentlemen) I like your Kudos!! !!
My YT Channel Dancing With Data !! Connect on Linkedin !!Power BI for Tableau Users 

[Anonymous]

Unfortunately it doesn't work or I don't know how to do it properly.

The filter i have already.

This I want to visualize in numbers: