Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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?
Solved! Go to Solution.
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)
Proud to be a Super User!
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)
Proud to be a Super User!
Works Perfect, Thanks!
you are welcome
Proud to be a Super User!
User | Count |
---|---|
139 | |
113 | |
103 | |
73 | |
63 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |