Is the following possible? in Desktop

[informatica]

I have 4 Tables:

•  Customer (contains field - limitCredit)
•  Movements
•  Bills
•  Order

I need to know which customers,  have  credit limit exceeded,

Te table Customer contains the field limitCredit

The limit Credit is calculated by : (Movements + Order )- Bills

Any idea how to do it?

[v-chuncz-msft · Accepted solution]

@informatica,

For DAX, you may start from GROUPBY Function and UNION Function.

[informatica · Accepted solution]

Thank you very much,

The idea is good for me, i'm just starting out  i'm a little lost .

[v-chuncz-msft · Accepted solution]

@informatica,

For DAX, you may start from GROUPBY Function and UNION Function.

[informatica · Accepted solution]

Thank you very much,

The idea is good for me, i'm just starting out  i'm a little lost .

[v-chuncz-msft · Accepted solution]

@informatica,

Any further question, share the sample data please. If the problem has been resolved, help to accept solution.