Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Monthly Rebate calculation help

When UTP hits $300,000 in "Total Year to Date" sales, we need to book 3% of that total over $300,000.  November works fine on the image I included.  The issue is December.  I need the result to not i...
Need Help
dkay84_PowerBI's avatar
dkay84_PowerBI
Microsoft Employee
9 years ago

The reference to [Month] was from the fictional table that the previous post used to solve your question.  You obviously update your formula with your table/column names.

 

In your screenshot, you have a column for month even if your YTD calculation used date (when you put YTD and Month Name in the table, it will filter all Dates for each month, so you get the aggregated YTD for each month).

 

If the formula given earlier doesn't work, try making a calculated table using SUMMARIZE to calculate your various metrics by month so that they all reside in one table and perhaps the formula given will work.

Anonymous's avatar
Anonymous
Not applicable
9 years ago

I hate being "that guy" but I am having all kinds of issues.  When I get up to the "Earlier" part of the formula, it is asking for "Column Name" and I think I want to enter DateDimension[MonthFull],-1 but it is not accepting anything.  I get the error below.

 

 

 

Here is without the comma