Repeat the MIN value for every row

[DataFab2023]

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!

[ryan_mayu · Accepted solution]

@DataFab2023 

maybe you can try this

Measure = 
sumx(FILTER(all('Table'),'Table'[occurreddate]=CALCULATE(min('Table'[occurreddate]),all('Table'))),[_total revenue 5])