Annual Plan Rate to Daily Rate (working days) and then apply to a calendar dates

[mattrixdesign2]

I have annual/12 months usages, I can break it down by work days (network days), for a daily usage rate for the year, and a forecasted amount based on the number of work days (network days) to date.

I would like to be able to build some visuals, which will require getting the run rate down to at least monthly (possibly daily), with a date, so I can compare with actuals.

Not sure where to begin, bare in mind all I have got is annual figures (not even monthly), and I really want to calculate based on working days (which I have been able to identify on my calendar table).

The plan usage source data is in XL so I have an opportuntity to manipulate some of the data there, but would prefer to do as much as possible in PBI.

I expect I need a new table to be able to have granular detail, and dates - but not sure how best to go about this.

[mattrixdesign2]

Hi, still not looked at it yet, had to move onto other stuff, I will get back on to it next week, need to think through what I am trying to achieve.

[Ashish_Mathur]

Hi,

Share some data to work with and show the expected result.

[mattrixdesign2]

ill take a fresh look tomorrow, thanks

[v-stephen-msft]

Hi @mattrixdesign2 ,

Pls has your problem been solved?

If it is, please accept the reply as a solution, and more people will benefit.

If not, please provide me with more information. You could post the sample data and the expected result as tabulars. Pay attention to data privacy.

Best Regards,

Stephen Tao

[amitchandak]

@mattrixdesign2 , Based on what I got. You want to take month/year in visual for networkdays

a new measure

sumx(table, networkdays( max(Table[Start], min(date[Date]) ), Min(Table[End], max(date[Date]) ),1) )

Power BI - Business day with and without using DAX Function NETWORKDAYS
Power BI - Business day with and without using DAX Function NETWORKDAYS: https://www.youtube.com/watch?v=Qs03ZZXXE_c