Forum Discussion

realdanielbyrne's avatar
realdanielbyrne
Frequent Visitor
7 years ago

Rolling Average Averagex, Time Intelligence with Date Table is incorrectly ignoring zero sales day

  The Dates Table is linked to the Sales table by Date. Date Table: Dates = CALENDARAUTO()   Total Sales from Fact Table: Total Sales = Sum[Sales]   My 14 day rolling average DAX  14 Day Ave...
Need Help
v-piga-msft's avatar
v-piga-msft
Icon for Resident Rockstar rankResident Rockstar
7 years ago

Hi realdanielbyrne,

 

The solution of  Chihiro should meet your requirement.

 

If you have solved your problem, please accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

 

If you still need help, please feel free to ask.

 

Best  Regards,

Cherry