Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Issue with Circular Dependency! Need Help!

Hello Team,   I am trying to create a couple of measures and running into a circular dependency, the measures are as below: Remaining = Start of Day - (sum of all tickets closed that day) Start o...
Need Help
amitchandak's avatar
amitchandak
Super User
6 years ago

Make sure you have a date table in your database, Mark that as the date table in Power BI. Then these formulae can be used for today and yesterday

 

Day behind Sales = CALCULATE(SUM(Sales[Sales Amount]),dateadd('Date'[Date],-1,Day))
Today  = CALCULATE(SUM(Sales[Sales Amount]),filter('Date','Date'[Date]=Today())
// Today  = CALCULATE(SUM(Sales[Sales Amount]),today())

Please refer my blog on the direct query to check more on the date table

https://community.powerbi.com/t5/Community-Blog/Decoding-Direct-Query-in-Power-BI-Part-1-Time-Intelligence-in/ba-p/922885

 

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution.
In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blogs -Decoding Direct Query - Time Intelligence, Winner Coloring on MAP, HR Analytics, Power BI Working with Non-Standard TimeAnd Comparing Data Across Date Ranges
Connect on Linkedin

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi amitchandak ,

     

    Thanks for your response, but i am unsure how this can be applied in my scenario. As mentioned, my Start of Day measure and Remaining measure are interdependent and causing a circular dependency

     

    Start of Day = Added Today + Previous Day Remaining 

    Remaining = Start of Day - (various other metrics)