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
6 years ago

Anonymous  I base on three tables and four columns. 

date: Posting_Date (hierarchy: day, month, year) from "General Ledger Entries" table

values: Amount (as a sume) from "General Ledger Entries" table

and accounts from "dictionary VAT' table

 

I was trying to change your formula for my needs like that 

 

 

 

 

CALCULATE( 'General Ledger Entries'[Amount]; 
		DATEADD(
			'General Ledger Entries'[Posting_Date].[Miesiąc],
			-3,
			month
		)
	)

 

 

but still doesn't working