Forum Discussion
Calulating help
Hi Anonymous for solution as below, please create Date / Calendar Table in Power BI and connect / create relationship with your Year column.
After that please create following measures 83), adopt Sheet1 with your table name
To get visuals as below, please use Year colum from created Date / Calendar table
Sum of Base = SUM(Sheet1[Baseline])Sum of Effekt CO2 = sum(Sheet1[Effekt CO2])Running total =VAR __max_date = MAX ( 'Date'[Date] )VAR __base_line=[Sum of Base]VAR __running_total=CALCULATE ([Sum of Effekt CO2],'Date'[Date] <= __max_date,ALL ( 'Date' ))VAR __Result=__running_total+__base_lineRETURN __ResultDid I answer your question? Kudos appreciated / accept solution!
Hi Anonymous Informande is Date type column? It is only a date column with Year
In column Baseline there will always be a single amount for each year, like 208? Yes only 208, but I don't know if I'm thinking wrong or if the year 2022 should start with 208 and then calculate it based on "Summa of Effect CO2 (sustainability)"
Hi Anonymous for solution as below, please create Date / Calendar Table in Power BI and connect / create relationship with your Year column.
After that please create following measures 83), adopt Sheet1 with your table name
To get visuals as below, please use Year colum from created Date / Calendar table
Did I answer your question? Kudos appreciated / accept solution!
Hello !
The first solution worked great, but now when I want to filter on "åtgärder" or "Skede" it calculates wrong, do you know how to fix this? For exampel se he picture
I can add the test file I have if it easyier ?
Hi Anonymous measure for this case should use date related columns from Date / Calendar table
To get visuals as below, please use Year colum from created Date / Calendar table