Forum Discussion

ola1996's avatar
ola1996
Icon for Helper I rankHelper I
6 years ago

DAX formulas

Hello,  I'm new in DAX and I need some help. I try to create new measure to calculate the amount for my accounts. But the problem is that I have amount from each account by months. Like in the table...
DAX
DAX Calculation
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

This is very easy on condition that you've got the correct model.

[Balance -3Mth] =
	CALCULATE(
		[Balance],
		DATEADD(
			Calendar[Date],
			-3,
			month
		)
	)


Best

D

ola1996's avatar
ola1996
Icon for Helper I rankHelper I
5 years ago

Can you tell me how to create this formula if I want to add vaules from January to March and show it as a sum of March and January and with next months the same situation ?