Forum Discussion

teresadanna's avatar
teresadanna
Frequent Visitor
8 years ago
Solved

Multiple Measures Causing Circular Dependency

I have the following measures & columns:   Measures:   PYTD Hours = CALCULATE(sum(Table[Hours]), DATESBETWEEN([Date], 5/31/2017, NOW())) MTD Hours = TOTALMTD(sum(Table[Hours]),[Date])   Column...
Need Help
  • teresadanna's avatar
    teresadanna
    8 years ago

    I realized that this issue is actually the result of a bigger issue related to not having a date table for earlier calculations. Thanks for everyones help!

Interkoubess's avatar
Interkoubess
Solution Sage
8 years ago

Hi teresadanna,

 

Please share (send) dummy data with expected results to figure out what you want to do.

 

Thank you.

 

Ninter

 

 

  • teresadanna's avatar
    teresadanna
    Frequent Visitor
    8 years ago

    I realized that this issue is actually the result of a bigger issue related to not having a date table for earlier calculations. Thanks for everyones help!