Forum Discussion
Cumulative sum for measures with base value
Hello Fellow Power BI creators,
I have been dealing with this issue, which I am going to try explain on lines bellow, I also hope it will help others too
I have this in excel and I want to transform it into power bi
My data is structured as shown below, with tables linked through a 'DateKey' date column. I need to create a metric or a calculated column similar to what is displayed in the 'Measures' table in Excel. However, in the context of Power BI, this would be represented as a dedicated table of metrics.
Measures are aggregated in other measure like that measures_sum = measure 1 + measure 2 ... measure n
4 Replies
Hi Maxmilian ,
I don't see any value for B4-B9 in this graph, can you provide a more detailed sample data, thank you!
Best Regards,
Xianda Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
So what is the correct way to do this? Is there anyway to automatize the process? is there anyway to export the measures into excel or something?
Oh I see sorry, my bad, I tried t oload excel file which contains basically 4 table, the BegginingNumbers table is fact table which contains number and one date.. then Measures table which is just measures, I added date dimension just for better imagination but it is just measures, and datakey which is a calendar table, also added table bellow, where is what I am trying to achieve, I already have measures1..measures3 but need to create measure begginingnumbers and endingnumbers
Thank you so much in advanceedit: I chose read only.. I hope you can download a copy - I dont want griefers to adjust something they should not
Excel tablesHi Maxmilian ,
I am sorry , In this case, DAX formulas such as metrics and columns can't be computed because it involves Circular Dependency.
Best Regards,
Xianda Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
