Forum Discussion

slyfox's avatar
slyfox
Icon for Helper II rankHelper II
9 years ago

previous month

Hello, I have two linked tables, Fact_Sales and Dim_Callendar Requred a mesure with average calculation for the: Case A: Sum of Sales Qty for the last three months excluding current, divided by n...
Need Help
mrslyfox's avatar
mrslyfox
Icon for Helper II rankHelper II
9 years ago

Hello Phil_Seamark

 

Now it is working as expected for Case A.

How to deal with Case B ?

Phil_Seamark's avatar
Phil_Seamark
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

Hi mrslyfox

 

I think it might be a case of just tweaking the date ranges.  eg. the -3 to -2 as I have highlighed in red

 

Sum of Last Three Months inc current = 
		SUMX(
				DATESINPERIOD(
					Dim_Calendar[Date],
					DATEADD(STARTOFMONTH('Dim_Calendar'[Date]),-2,MONTH),
					3,
					MONTH),
					[Total Amount]
		)
  • mrslyfox's avatar
    mrslyfox
    Icon for Helper II rankHelper II
    9 years ago

    Hello Phil_Seamark

     

    yes, your measure is working as expected,

    How to calculate number of callendar days from currently selected 25-Apr till 1st of Feb ?