Forum Discussion

kala2's avatar
kala2
Helper III
4 years ago
Solved

Fill Dates incremental from January until ID changes

My table is in the following format: 


I want to add a new column with dates filled by month. When an ID changes i need to restart the date incremental from January like:


**When a year changes, the dates will increment by year:


Is it possible to achieve something like that?

General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • ryan_mayu's avatar
    ryan_mayu
    4 years ago

    kala2 

    you can try this

    Column = 
var _count=CALCULATE(COUNTROWS('Table (2)'),FILTER('Table (2)','Table (2)'[Project ID]=EARLIER('Table (2)'[Project ID])&&'Table (2)'[SAMPLE DATA]<=EARLIER('Table (2)'[SAMPLE DATA])))
return EDATE(date(2021,1,1),_count-1)

3 Replies

  • ryan_mayu's avatar
    ryan_mayu
    Super User
    4 years ago

    kala2 

    you can try this

    Column = 
var _count=CALCULATE(COUNTROWS('Table (2)'),FILTER('Table (2)','Table (2)'[Project ID]=EARLIER('Table (2)'[Project ID])&&'Table (2)'[SAMPLE DATA]<=EARLIER('Table (2)'[SAMPLE DATA])))
return EDATE(date(2021,1,1),_count-1)