Using DAX calculation how to calculate monthly budget till today in power bi Desktop

Question

Can someone suggest a sample DAX calculation formula where calculate monthly budget will be added?

Answer 1

You can make use of this:

MTD Budget = SUMX(Budget,
                  Budget[Budget] *
                  IF(MONTH(TODAY()) <= MONTH(Budget[PostDate], 1, BLANK()) *
                  IF(MONTH(TODAY()) = MONTH(Budget[PostDate]),
                     DIVIDE(DAY(TODAY()), DAY(EOMONTH(Budget[PostDate],0))), 1))

Preparing for Power BI exam? Check out Power BI Syllabus now!