Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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,
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.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
47 | |
26 | |
22 | |
12 | |
8 |
User | Count |
---|---|
77 | |
50 | |
46 | |
16 | |
12 |