Forum Discussion
How do I make a chart dynamically change based on a data set with a user input?
I have a table with the amount of power usage and cost per month for the last 2 years. I want to look at projecting how much it would cost for the next few years based on a user input (by using a...
amitchandak
Super User
Super UserAnonymous , Something like this with help from date table for 2021 onward
Year behind Cost= CALCULATE(SUM(Table[Cost]),dateadd('Date'[Date],-1,Year)) *1.05
Year behind Cost= CALCULATE(SUM(Table[Cost]),SAMEPERIODLASTYEAR('Date'[Date]))*1.05
You can merge two column based on today
if(max(Date[Year]) < Year(Today()) , SUM(Table[Cost]) ,[Year behind Cost])