Forum Discussion
Using Parameter to Divide
Are you wanting to do this as a filter in the report or the Power Query stage? If in the report you'll need to use a MEASURE to be able to reference the SELECTEDVALUE of the slicer, but I feel like this might be better done in the Power Query stage?
Here's the Measure solution:
Total Dollars MEASURE = DIVIDE( SUM(Table[Total Dollars]), SELECTEDVALUE(Parameter[NumberMonths], 1))
How often are you sent this data and is it being combined into one report?
Have you worked with Parameters in Power Query before? Here's an intro you can follow along with on how they work,
Use Parameters to Combine Data
Your requirement is slightly different, but same concept. Depending on how you combine and work with this data, the exact solution will vary so if you can provide a bit more info we can provide a better solution.
Are you wanting to do this as a filter in the report or the Power Query stage? If in the report you'll need to use a MEASURE to be able to reference the SELECTEDVALUE of the slicer, but I feel like this might be better done in the Power Query stage?
Here's the Measure solution:
Total Dollars MEASURE = DIVIDE( SUM(Table[Total Dollars]), SELECTEDVALUE(Parameter[NumberMonths], 1))
How often are you sent this data and is it being combined into one report?
Have you worked with Parameters in Power Query before? Here's an intro you can follow along with on how they work,
Use Parameters to Combine Data
Your requirement is slightly different, but same concept. Depending on how you combine and work with this data, the exact solution will vary so if you can provide a bit more info we can provide a better solution.
Thank you. I am using this as a filter on a report so creating the new measure worked.