Forum Discussion

BI_Newbie2's avatar
BI_Newbie2
Regular Visitor
2 years ago

Help with YTD Average Calculation

Hello, I've been trying to calculate the YTD Average for each criteria row in a table (each criteria represents a KPI, there's 32) each criteria has multiple rows in my FACT table.  I want to have t...
Need Help
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
2 years ago
for example:  user selects July, YTD column updates to Jan-Jun, user selects December YTD column updates to Jan-December

So you are excluding July but including December?