select value from the table based on current month

[dkushner]

Hi,

I've been struggling with writing a DAX statement that will solve this, and would greatly appreciate any help!

I have a table

BudgetPeriod	BudgetMonthlyRubles	DaysInMonth
01.01.2018	3978728	31
01.02.2018	4012188	28
01.03.2018	4319828	31
01.04.2018	4518324	30
01.05.2018	4592812	31
01.06.2018	4752517	30
01.07.2018	5615683	31
01.08.2018	4110937	31
01.09.2018	5326105	30
01.10.2018	5451250	31
01.11.2018	5054974	30
01.12.2018	5151887	31

I need to create a measure that will return the value from the column "BudgetMonthlyRubles" based on the current month and year, so for the january 2018 I should get as a result 3978728

[Drors · Accepted solution]

Create new measure:

BudgetThisMonth = calculate(sum(BudgetMonthlyRubles),year(table[budgetPeriod])=year(now()),month(table[budgetPeriod])=month(now()))

[gooranga1]

Hi @dkushner

You can create a column in your table that extracts the month and year from current date using now() and set the day to 1 then compare that with BudgetPeriod. You will have to format your BudgetPeriod as a type date otherwise you will have to create a string of the date which is possible.

Replace "column1" with BudgetPeriod in your case. You can then filter on the table where [Current Date]=1.

Current Date = if(DATE(year(now()),month(now()),01)=Table3[Column1],1,0)

 

[dkushner]

Sorry, but I don't understand how it is helping me )
I need to get 1 number to use it later in further calculations