86289/using-calculation-calculate-monthly-budget-power-desktop
Can someone suggest a sample DAX calculation formula where calculate monthly budget will be added?
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))
Hi Ramya, I found these two function that ...READ MORE
Hi Phalguni, Thanks for your question. It used ...READ MORE
1. Click anywhere on the page. 2. Go ...READ MORE
Hi, @vnk You can make use of this ...READ MORE
Using the CALCULATE function makes the DAX perform a context ...READ MORE
You need a way for the measure ...READ MORE
Here's an example using the AdventureWorksDW data ...READ MORE
This is not only a running total ...READ MORE
You can go through this: column = IFERROR( ...READ MORE
If you use the date column from FactTable, ...READ MORE
OR
Already have an account? Sign in.