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 below.

 

And I want to see amount from January in April, from February in May, from March in June, from April in July, from May in August, from June in September and so on.

 

My question is, how can I do it by DAX formulas?

 

 

DAX
DAX Calculation
Need Help

8 Replies

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