Calculating daily Sales

[zibster]

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

[v-lid-msft · Accepted 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,

[zibster]

This was very helpful

Thanks 

[amitchandak]

 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...