Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

looping logic to create new column

I have a 'Total Target' value and I want to achieve this 'Target Kg' column which is nothing but Total Target on the daily basis   So here is the logic how we getting target based on each date:   ...
Need Help
Show and Tell
Tips and Tricks
tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
4 years ago

Hi Anonymous 
How does your source data look like? Is it one table or multiple? Do you have a date table? Relationships? What are the names of Tables/Columns involved? Is the total target a total sum of a column or a given fixed value or a parameter? 

Anonymous's avatar
Anonymous
Not applicable
4 years ago

yes I have multiple tables (calendar, target) and Total Target is a sum of coumn. It's just I want this Total Target to be segregated on the day basis with the above logic I gave.

But I don't know how can I apply this looping condition with DAX. I just need a pseudo code for this logic.

  • tamerj1's avatar
    tamerj1
    Icon for Community Champion rankCommunity Champion
    4 years ago

    Anonymous 
    Please present sample data of both tables along with the expected result.

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Can you tell me the logic how can I return a cumulative sum like 'var x' + 'var x' of previous date in dax calculated column?