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,880 points
142 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,870 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
• 32,910 points
7,698 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,076 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
• 32,910 points
127 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
153 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,870 points
106 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,870 points
83 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,870 points
297 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,870 points
81 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,870 points
206 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,870 points
125 views