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 

  • 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 ?