Forum Discussion
Dunner2020
Post Prodigy
Post Prodigy24 hrs sum column
Hi there, I have a data set that looks like as shown in the picture: In the data EpochHH is the unique number that represents the half-hour time slot of the given date. Now I want to cr...
Hi Dunner2020 ,
Please use the following calculated column:
24 hrs Value = CALCULATE(SUM('Fact Table'[30 Mins Value]),FILTER('Fact Table','Fact Table'[EpochHH]<=EARLIER('Fact Table'[EpochHH])+47 &&'Fact Table'[EpochHH]>=EARLIER('Fact Table'[EpochHH])))If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai
Dunner2020Post Prodigy
Post ProdigyJihwan_Kim , thanks for your reply. However, the above-mentioned formula does not produce the desired result as shown in the picture:
The first value shown in 24hrs values column should have been the sum of first two values of 30 Mins values column.
v-deddai1-msft
Community Support
Community SupportHi Dunner2020 ,
Please use the following calculated column:
24 hrs Value = CALCULATE(SUM('Fact Table'[30 Mins Value]),FILTER('Fact Table','Fact Table'[EpochHH]<=EARLIER('Fact Table'[EpochHH])+47 &&'Fact Table'[EpochHH]>=EARLIER('Fact Table'[EpochHH])))
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai