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
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

Anonymous ,Based on what I got

Join this with a date table having all the dates,

 

Then you can have data for all dates like

calculate(lastnonblankvalues(Table[Date], Sum(Table[Target Qty])), filter(all('Date'), Date[Date] <= max(Date[Date]) ) )