Forum Discussion

AnilKumar's avatar
AnilKumar
Helper II
6 years ago
Solved

repeat column values based on another column

Hi all, I am Struggling since long back. I have data like  Order num original date actual date invoiced amt times Order1 June-2016 June-2016 1 Order1 sept-2016 march-2017 3 Ord...
Data Modeling
  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    6 years ago

    Hi AnilKumar, 

     

    You can create a index column in Query Editor firstly: 

     

     

    Then create calculated columns below: 

     

    EndRowNum = CALCULATE(SUM('Table'[invoiced amt times]),FILTER('Table','Table'[Index]<=EARLIER('Table'[Index])))
     
    StartRowNum = 'Table'[EndRowNum]-'Table'[invoiced amt times]+1
     
    Column = CALCULATE(MIN('Table'[actual date]),FILTER('Table',EARLIER('Table'[Index])>='Table'[StartRowNum]&&EARLIER('Table'[Index])<='Table'[EndRowNum]))
     
     

    Best Regards,
    Qiuyun Yu 

v-qiuyu-msft's avatar
v-qiuyu-msft
Community Support
6 years ago

Hi AnilKumar, 

 

You can create a index column in Query Editor firstly: 

 

 

Then create calculated columns below: 

 

EndRowNum = CALCULATE(SUM('Table'[invoiced amt times]),FILTER('Table','Table'[Index]<=EARLIER('Table'[Index])))
 
StartRowNum = 'Table'[EndRowNum]-'Table'[invoiced amt times]+1
 
Column = CALCULATE(MIN('Table'[actual date]),FILTER('Table',EARLIER('Table'[Index])>='Table'[StartRowNum]&&EARLIER('Table'[Index])<='Table'[EndRowNum]))
 
 

Best Regards,
Qiuyun Yu 

AnilKumar's avatar
AnilKumar
Helper II
6 years ago

Thanks. It worked for my case.