Forum Discussion
Calculated column Shows Repeated Values
Hello All, I am working on a measure but im getting repeated values across all the months, can you please assist on what I am missing on the dax commands? Thank you!! I am using the fo...
Your Layout[FROM] and Layout[TO] values are numeric. Did you mean to specify date ranges instead?
Replace the item SUBTOTAL field with the Value field:
I am trying to have the Item subtotal formula use the primary Key which is numeric to do the corresponding additions based on the PK from and to so for example PK 186 is revenue, PK 203 is cost of goods sold and PK 222 gross margin should be the addition of the values for PK 186 through PK 203. hope this helps clarify, Thank you for your assistance