Dax for avaibality

[MathildaP]

Dax for avaibality 

Assignee (Have this data)	Starteddate of a ticket (Have this data)	Estimated hours (How long a task will take) (Have this data)	Due date of ticket (Have this data)	Estimated hours per month (I need a formular for this)
Person 1	1st of April for example	100	(Could be 3 months ahead for example)	Due date MINUS created date (estimated hours)/AMOUNT OF MONTHS
				100/3

[selimovd · Accepted solution]

Hey @MathildaP ,

a few sentences of explanation would help to understand the problem a little better.

Add the following calculated column:

Estimated hours per month =
DIVIDE(
    myTable[Estimated hours],
    DATEDIFF(
        myTable[Starteddate],
        myTable[Due date],
        MONTH
    )
)

If you need any help please let me know.

If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards

Denis

Blog: WhatTheFact.bi

Follow me: twitter.com/DenSelimovic