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

mattbrice's avatar
mattbrice
Icon for Solution Sage rankSolution Sage
9 years ago

Are Date, Product, Product Color all from the same table?  Is Value of units sold a measure; and what table is it derived from?  Are you looking for a measure for Percent of day Sales?  Without some details on model design it is difficult to provide formula needed.

 

This may work making assumptions about model normalization:

 

Percent of day sales =
VAR value_today = [Value of units sold]
VAR all_sales_today =
    CALCULATE (
        [Value of units sold],
        ALL ( Table[Product], Table[Product Color] )
    )
RETURN
    DIVIDE ( value_today, all_sales_today )

 

 

  • ZKailar's avatar
    ZKailar
    Frequent Visitor
    9 years ago

    Sorry about the confustion. Date, product, product color are from the same table. Value of units sold is also on the same table. I dont think a measure would work (i could be wrong), becasue i need the percentages to stay the same regardless of report filters. I think it just needs to be an additional column. Sorry, im still new to this, excel is what i am used to.