This is a hard one :)

[RvdHeijden]

I need a difficult formula to calculate the following.

I got 2 colums with dates in them and i calculated the difference (in minutes) between the 2 dates with the help of this forum for example 78 minutes or 1256 minutes

Now i have another table with, per client, different times in which i have to resolve an issue say for Clien A i have to resolve an issue with 120 minutes

I need a formula that compares the value in table 1 in combination with the TypeSLA for example:

Issue 1 for TypeSLA A (Column A) has been resolved in 100 minutes (Column B)

Table 2 has al the clients in it with the TypeSLA in which a issue has to be resolved, a sort of contract.

It has to compare the time needed to resolve the issue with the time i agreed to with the client and the result is either 'in time' or 'to late'

Hopefully someone can help me with this

[Greg_Deckler]

Not sure of your data model, I did this, created an Enter Data query "Tickets":

Type        Minutes

A	100
B	50
A	1000
B	3

Created another one, SLA's:

Type        Minutes

A	120
B	40

Related the two tables on "Type". Created a column in Tickets with the following formula:

Met = IF([Minutes]<RELATED(SLAs[Minutes]),"met","not met") 

[RvdHeijden]

@Greg_Deckler

A collegue of mine said it is possible to copy colums from table A en B in a new table.

That way i can use colums from different sources into 1 table and use a simple formula greater then > or less then <

But how can i use/copy colums from table 'Tickets' and 'SLA' into a new table ?

There is already a relationship between 'TypeSLAId' en 'Id' in the table SLA

[Greg_Deckler · Accepted solution]

Well, you could create a new query and perform a Merge (join) on them to create a new combined table. This is in the Query Editor.

You could also create a new table in the Modeling tab and possibly do something with DAX functions like CALCULATETABLE and SUMMARIZE, but not sure if either of those will get you where you want to be, but there may be another DAX function that will.

If you right click a table in the data model, you can choose to "Copy Table" but I do not know of a way to paste it back into the model, it is really for copying and pasting into other programs.

Finally, you could create a new table from scratch and essentially lookup values from the other tables but you would have to seed that table with something and build the relationships such that you could lookup the correct values.

Otherwise, not sure what your colleague is referring to but always willing to learn some new way of doing things.