Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello everyone,
I have a measure to calculate the sum of expenses from previous moth which is the following one:
Expenses Last Month= calculate(sum(Gastos[Value]);filter(ALL('Calendar'[Year]);'Calendar'[Year]=[MaxYear]);filter(ALL('Calendar'[Nr Month]);'Calendar'[Nr Month]=[MaxMonth]);ALL('Calendar'[Month]))
I want to show on the table, sum values last month to current day last month and with that formula, it showing the sum of all the days last month ( 30, but it is suposed to sum just to day 14 ) !
anyone have an idea?
Thanks
Solved! Go to Solution.
I create two columns in the “Gastos” table with following formulas. Please confirm if it is what you want.
LastMonth_Date = DATEADD( 'Calendar'[Date] , -1, MONTH )
Expenses Last Month = CALCULATE ( SUM ( Gastos[Value] ), DATESBETWEEN ( Gastos[Date], STARTOFMONTH ( Gastos[LastMonth_Date] ), Gastos[LastMonth_Date] ) )
Best Regards,
Herbert
I create two columns in the “Gastos” table with following formulas. Please confirm if it is what you want.
LastMonth_Date = DATEADD( 'Calendar'[Date] , -1, MONTH )
Expenses Last Month = CALCULATE ( SUM ( Gastos[Value] ), DATESBETWEEN ( Gastos[Date], STARTOFMONTH ( Gastos[LastMonth_Date] ), Gastos[LastMonth_Date] ) )
Best Regards,
Herbert
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
96 | |
81 | |
74 | |
66 |
User | Count |
---|---|
126 | |
106 | |
105 | |
86 | |
72 |