Forum Discussion

ZKailar's avatar
ZKailar
Frequent Visitor
9 years ago
Solved

Formulas based on sales perecents

I am working on getting the BI formated so i can connect to a server for data instead of using excel. One of my main formulas is using percentages based on sales per day. I believe i need to make a n...
  • Vvelarde's avatar
    Vvelarde
    9 years ago

    ZKailar

     

    Hi, create a calculated column with:

     

    PercentofDaySales =
DIVIDE (
    Table1[Value of Units Sold],
    CALCULATE (
        SUM ( Table1[Value of Units Sold] ),
        FILTER ( Table1, Table1[Date] = EARLIER ( Table1[Date] ) )
    )
)

    Regards

     

    Victor

    Lima - Peru

Vvelarde's avatar
Vvelarde
Icon for Community Champion rankCommunity Champion
9 years ago

ZKailar

 

Hi, create a calculated column with:

 

PercentofDaySales =
DIVIDE (
    Table1[Value of Units Sold],
    CALCULATE (
        SUM ( Table1[Value of Units Sold] ),
        FILTER ( Table1, Table1[Date] = EARLIER ( Table1[Date] ) )
    )
)

Regards

 

Victor

Lima - Peru