Projected Hours will not show for the future months....

[Anonymous]

I need help understanding how to populate future available work hours in my table.  Feb, Mar, Apr populate correctly but future months (May, Jun, Jul, etc) do not.  Attached is my table with the formula filtered for the Year 2020. I have also attached a visual of my Date Table which runs through 2028.Projected Available Hrs FormulaDate Table - Work Hrs Column

[v-kelly-msft]

Hi @Anonymous ，

Whether column [trWork Hours] contains the data about future months?Your measure seems no problem...If it's available,can you upload your .pbix file to onedrive business and share the link with us?Remember to remove the confidential information.

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[Anonymous]

Hi Kelly, Greg,

The goal is to report the Projected Utilization each month going forward using the following formula:

Projected Utilization = Estimated Hours / Available Hours

At issue is, I cannot get to Projected Utilization for future months due to Available Hours being blank.

I don't need Available Hours to display in my table but I sure do need the Projected Utilization number.

Here is what my end result would look like if I have all 3 fields (Estimated Hours, Available Hours, Projected Utilization) displayed in my table:

Yellow is my goal. Light blue is the problem as it is blank for future months.

Thank you both for trying to guide me.

[v-kelly-msft · Accepted solution]

Hi @Anonymous ,

So you wanna know how to calculate the available hours in futue months?

If so,you can create a calendar table ,then create 2 calculated columns using below dax expressions:

Month = MONTH('Table'[Date])

_Available hours = IF(WEEKDAY('Table'[Date],2)<6,8,0)

And you will see:

If it isnt what you need,could you pls upload your .pbix file and share the link with us?

Here is the related .pbix file.

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[Anonymous]

Hi Kelly,

Thank you for the formula's.  I recreated your and they validate that my calculations were exactly the same.  That led me to think the issue must be around relationships.  Your sample file validated that.  So I went into my file and worked the relationships and now I am getting the results I wanted.

Thank you for leading me down the path to solve my problem!

[Greg_Deckler]

Could you post sample information as text? What are you expecting to be the values for those future months? Why?

Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490