Forum Discussion
Solved
SUMX Blank Values with Expression using RELATED value
Hello all, i have this formula which was working. After i retouched some parameters in data modeling with Power Query, it doesn't work anymore, though all queries are error free and relations bet...
Hi, you dont have any matching Product IDs. The relationship between two tables is on Product id and Numéro de l'objet
Hi olgad
Thank you ! both columns should contain same numbers, because one has been copied from single values from the other (sales report).
PS: after reviewing it again this morning, the problem came that i formatted one column as Int64.Type in Power Query (though it appeared correctly in power query, once in DAX, it has been formatted with 000000 at the end), don't know why exactly
Thank you again ! i was so confused yesterday i couldn't think clearly
Have a nice day !
Steve