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.
Hi,
I am trying to calculate daily projection from the total weekly amount, the %ByDayForTheWeek is a calculated value. Below is an example of how I would do this in excel. Please help
Solved! Go to Solution.
Hi @zibster ,
We can try to create a calculated column in “Split By Day Table” Table using following dax to meet your requirement:
Ounput =
[%ByDayForTheWeek]
* CALCULATE (
SUM ( 'Sales Table'[SalesProj] ),
FILTER (
'Sales Table',
'Sales Table'[Facility] = EARLIER ( 'Split By Day Table'[Facility] )
&& 'Sales Table'[Department] = EARLIER ( 'Split By Day Table'[Department] )
&& 'Sales Table'[WeekID] = EARLIER ( 'Split By Day Table'[WeekID] )
)
)
If it doesn't meet your requirement, kindly share your sample data and expected result to me if you don't have any Confidential Information. Please upload your files to One Drive and share the link here.
Best regards,
Hi @zibster ,
We can try to create a calculated column in “Split By Day Table” Table using following dax to meet your requirement:
Ounput =
[%ByDayForTheWeek]
* CALCULATE (
SUM ( 'Sales Table'[SalesProj] ),
FILTER (
'Sales Table',
'Sales Table'[Facility] = EARLIER ( 'Split By Day Table'[Facility] )
&& 'Sales Table'[Department] = EARLIER ( 'Split By Day Table'[Department] )
&& 'Sales Table'[WeekID] = EARLIER ( 'Split By Day Table'[WeekID] )
)
)
If it doesn't meet your requirement, kindly share your sample data and expected result to me if you don't have any Confidential Information. Please upload your files to One Drive and share the link here.
Best regards,
This was very helpful
Thanks
If possible please share the Excel and sample pbix file after removing sensitive information.Thanks.
My Recent Blog -
https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...
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 |
---|---|
113 | |
99 | |
80 | |
70 | |
59 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |