Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Need Assistance on Error about Circular Dependency

Hi,   I managed to create a column for variance using the dax below   Variance = CALCULATE(SUM(GRV_SalesItems[Sales Price])) - CALCULATE(SUM(GRV_SalesItems[Purchase Price]))    But when I trie...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi Anonymous ,

    Please try the following formula:

    Variance = ([Sales Price] - [Purchase Price]) / [Purchase Price]

    Create the new column to classify the variance.

    Variance classification = 
IF([Variance] > 0, "Positive", 
    IF([Variance] < 0, "Negative", "Zero")
)

    Drag the date column into the slicer visual.

    Best Regards,

    Wisdom Wu

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.