Forum Discussion
Solved
Repeat the MIN value for every row
Hi all,
How can I grab the first date's value and repeat for every other day?
For example I have the measure below:
and I need to repeat the value of 320 which is the first date for every other row
the reason I need to do that is for divide after
thanks!
maybe you can try this
Measure = sumx(FILTER(all('Table'),'Table'[occurreddate]=CALCULATE(min('Table'[occurreddate]),all('Table'))),[_total revenue 5])
1 Reply
maybe you can try this
Measure = sumx(FILTER(all('Table'),'Table'[occurreddate]=CALCULATE(min('Table'[occurreddate]),all('Table'))),[_total revenue 5])