Multiply with a What if Meassure, based on Month..

[NicolasD]

Hi all,

got a question when it comes to dynamic calcualtion inside the Visuals.

I got a Dataset with a Revenue Colum for a couple of years.

Now i want to calculate an Upraise in Revenue based on a monthly % for a specific twelf month.

I included the What if Meassures with a slider, but canot figure out, how i can add in a new table, which i created with a date colum on the beginning based on the model, to calculate the % multiple the Revenue based on the month.

For example, the left side are the what of Meassures from January (Top) to Deembre (Bottom)

I figuered out, that i use a Datapicker in the bottom to be able to select the dateframe i like to use, i.e. there are on the Books data and Forecast data mixed in a dataset.

hope you guys understand my request and i made my point. if not, please feel free to ask,

[Anonymous]

Do you want revenue calculation based on selected month?

Note: Calculated columns and tables are calculated at first load only they can be dynamic.

For dynamic calculations you need to create measure.

Thanks & regards,
Pravin Wattamwar
www.linkedin.com/in/pravin-p-wattamwar

If I resolve your problem Mark it as a solution and give kudos.

[Anonymous]

Do you want revenue calculation based on selected month?

Note: Calculated columns and tables are calculated at first load only they can be dynamic.

For dynamic calculations you need to create measure.

Thanks & regards,
Pravin Wattamwar
www.linkedin.com/in/pravin-p-wattamwar

If I resolve your problem Mark it as a solution and give kudos.