KPI to today

[Wubek]

Hello,

I have a question about creating a KPI chart with a percentage of budget filling. I have a budget plan for the full month (currently May) and I want the KPI to show a number only up to today. For example, I have sales data that refreshes daily and a budget plan for the current month. I have a KPI for the full month (sales data up to today and budget up to the end of the month) and I also want to have a KPI with sales and budget data up to today. What set analysis should I use?

[Chanty4u · Accepted solution]

Not sure but try this 

sum({<Date={"<=$(=Today())"}>} Sales) / sum({<Date={"<=$(=MonthEnd(Today()))"}>} Budget)

[Wubek]

Thank you very much!