Forum Discussion
RNorth
3 years agoNew Member
Cannont Convert Value Error
Like many others im getting the error that is inicating its returning test and not a value. However both columns (trade price, and % difference) are values and not text so im struggling how to get ri...
RNorth
3 years agoNew Member
Here is one of the data sets. The other im pulling from a data cube through a direct query so i cannot screen shot that informatoin.
- MohammadLoran253 years ago
Solution Sage
What do you want to achieve by creating this calculated column?
I cannot understand the logic of the way u have used the CALCULATE Function.
- RNorth3 years agoNew Member
My intent was to sum the amounts of the trade agreements for each item for each company an multiply it by the % difference using the same filters of item and company.
- RNorth3 years agoNew Member
Im very new to writing dax and its still a little confusing to me at times so any suggestions are appreciated.