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 All,
Does anyone know how to change the below formula to get the total column to total properly? That is to sum Nov + Dec?
I finally got the column to total (Nov and Dec) however now the total column does not total.
Here is the formula I used:
Solved! Go to Solution.
Hi @Anonymous
Please try
Forecast =
VAR ForecastTable =
ADDCOLUMNS (
SUMMARIZE ( Data, Data[Partner & Payment Type], 'Date'[Month] ),
"Rate", [Forecast - Rate],
"Population", [Headcount Total],
"FFS", [Forecast - FFS Sum]
)
RETURN
SUMX ( ForecastTable, ( [Rate] * [Population] ) + [FFS] )
Hi @Anonymous
Please try
Forecast =
VAR ForecastTable =
ADDCOLUMNS (
SUMMARIZE ( Data, Data[Partner & Payment Type], 'Date'[Month] ),
"Rate", [Forecast - Rate],
"Population", [Headcount Total],
"FFS", [Forecast - FFS Sum]
)
RETURN
SUMX ( ForecastTable, ( [Rate] * [Population] ) + [FFS] )
Thanks Again!!!!!!
Hi @Anonymous ,
Can you share sample pbix after removing sensitive data, so that we can check the Total, Nov and Dec column structure in your report?
Thanks!
Inogic Professional Service Division
An expert technical extension for your techno-functional business needs
Power Platform/Dynamics 365 CRM
Drop an email at crm@inogic.com
Service: http://www.inogic.com/services/
Power Platform/Dynamics 365 CRM Tips and Tricks: http://www.inogic.com/blog/
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 |
---|---|
43 | |
21 | |
20 | |
15 | |
13 |
User | Count |
---|---|
45 | |
41 | |
39 | |
19 | |
19 |