Forum Discussion

dkushner's avatar
dkushner
Frequent Visitor
8 years ago
Solved

select value from the table based on current month

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 ...
Need Help
  • Drors's avatar
    Drors
    8 years ago

    Create new measure:

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

Drors's avatar
Drors
Resolver III
8 years ago

Create new measure:

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