Anyway to use "sum.if" from excel in powerbi?

[Anonymous]

I'm working in a strange schema, i don't have relashionships... basicly I have 3 fact tables (sales, giveback and discount)

sales table have 4 columns: Date, Client, Product and Value.
giveback and discount table have 3 columns: Date, Client and Value.

To calculate some measures, I need to multiply the value for the percentage of sales value that value represent...

for example...

after "cross" using sum.if



At "production" we have date filter using only to filter the tables, we don't show that column... when I add it in power bi my measure keeps "respecting" dates and dont "cross" the tables, for example...



Maybe the difference between dates?

Our giveback happend for client 837 in 9/6/2017 but we don't have sales in 9/6/2017, so the table don't show my giveback values...

I want "work like excel". Any idea?

[ricardocamargos]

Hi @Anonymous,

Why don't u append the 3 tables into just one ?

Also if u wanna calculate values before aggretation you should use the X functions (SUMX, COUNTX, MAXX....)

I hope it helps,

Ricardo