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

0 votes

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

Sep 24, 2020 in Power BI by anonymous
• 8,890 points
334 views

1 answer to this question.

0 votes

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))
answered Sep 24, 2020 by Gitika
• 65,950 points

Related Questions In Power BI

0 votes
1 answer

How to rename a column using DAX in Power BI?

Hi Ramya, I found these two function that ...READ MORE

answered Aug 21, 2019 in Power BI by anonymous
• 33,010 points
11,226 views
0 votes
2 answers

How to format negative numbers in red parenthesis in Power BI Desktop?

Hi Phalguni,  Thanks for your question. It used ...READ MORE

answered Jun 10, 2020 in Power BI by Excel
• 140 points
4,791 views
0 votes
1 answer

How to set Automatic page refresh in Power BI Desktop?

1. Click anywhere on the page. 2. Go ...READ MORE

answered Oct 29, 2019 in Power BI by anonymous
• 33,010 points
186 views
0 votes
1 answer

how to write dax calculation Power bi

Hi, @vnk You can make use of this ...READ MORE

answered Aug 5, 2020 in Power BI by code_Damon
200 views
0 votes
1 answer

Understanding the DAX CALCULATE function

Using the CALCULATE function makes the DAX perform a context ...READ MORE

answered Sep 28, 2020 in Power BI by Gitika
• 65,950 points
273 views
0 votes
1 answer

DAX Userelationship function

 You need a way for the measure ...READ MORE

answered Oct 5, 2020 in Power BI by Gitika
• 65,950 points
166 views
0 votes
1 answer

Using RELATED function in DAX with USERELATIONSHIP

Here's an example using the AdventureWorksDW data ...READ MORE

answered Nov 17, 2020 in Power BI by anonymous
• 65,950 points
1,215 views
0 votes
1 answer

How to restart running total column with Power BI Desktop DAX?

This is not only a running total ...READ MORE

answered Dec 8, 2020 in Power BI by Gitika
• 65,950 points
368 views
0 votes
1 answer

How to convert eight digit yyyymmdd to date using DAX in Power BI ?

You can go through this: column = IFERROR( ...READ MORE

answered Dec 8, 2020 in Power BI by Gitika
• 65,950 points
911 views
0 votes
1 answer

How to measure in DAX to calculate YTD for chosen month only for Power BI?

If you use the date column from FactTable, ...READ MORE

answered Dec 22, 2020 in Power BI by Gitika
• 65,950 points
722 views