Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

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 parameter) from a percentage.

 

For example, in January 2021 - 1021 Volts were used and costs $1200, and in Febraury 2021 - 1202 Volts were used and costs $1400.

Example table:

MonthVoltage UseCost
January 202110211200
February 202112021400
etc...etc...etc...

Then the user will input a 5% voltage use increase for the next year (by using a parameter), I want to see the 5% increase on the voltage and costs for those months. I want the line chart to show those new values based on the 5% increase of the values in the table from 2021 to present.

 

Is there a DAX formula to create this kind of calculations and work with a user input?

 

Still a newbie so any help would be appreciated.

 

Thank you!

Need Help
Tips and Tricks

1 Reply

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    Anonymous , 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])