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?