Forum Discussion

beast314's avatar
beast314
Frequent Visitor
5 years ago
Solved

calculating run rate

Hi all, I am new to Power Bi and this may seem like nothing but, I am stuck on a problem and I have no idea how to proceed further with it. So I have live sales data for the 90 days from which I hav...
General Comment
Need Help
  • Icey's avatar
    Icey
    5 years ago

    Hi beast314 ,

     

    My previous measure works in this sample. Do I miss anything?

    Note: I didn't return any value for year level in the Matrix value, because I don't know your calculation logic for year.

     

     

    Best Regards,

    Icey

beast314's avatar
beast314
Frequent Visitor
5 years ago

Fowmy 

It is something like it

Date                 Sales_Quantity

12/07/2021           10

11/07/2021             5

10/07/2021             <Blank>

09/07/2021             8

08/07/221               6

07/07/2021              8

06/06/2021              2

 

If such data is given to me then I want a calculated column of (10+5+8+6+8+2)/6  =39/6 = 6.5

I have data in segment-wise so for each column I need the run rate. I don't care as long as I can present it in the matrix form. Like for segment A-> (11+8+3)/3 = 7.33

                                                 B-> (14+13+14)/3 = 13.66 

                                                  C->(3+7)/2 = 5

Fowmy's avatar
Fowmy
Icon for Super User rankSuper User
5 years ago

beast314 

You either use simple average as it excludes blanks 

Run Rate =  AVERAGE( Table6[Quantity] )

 
Or specify explicitly 

Run Rate = 
CALCULATE(
    AVERAGE( Table6[Quantity] ),
    Table6[Quantity] > 0
)
  • beast314's avatar
    beast314
    Frequent Visitor
    5 years ago

    Fowmy 

    How to put the date condition in this.

    This table was made by making a measure

    Quant30 = CALCULATE( SUM('Table'[Quantity]), FILTER( ALL('Table'[date]),'Table'[date]> TODAY()-30))
    How can I take an average of measure?
    • Fowmy's avatar
      Fowmy
      Icon for Super User rankSuper User
      5 years ago

      Quant30 = CALCULATE( Average('Table'[Quantity]), FILTER( ALL('Table'[date]),'Table'[date]> TODAY()-30 && 'Table'[date]< TODAY()),

      Table'[Quantity] > 0

       

      )

      • beast314's avatar
        beast314
        Frequent Visitor
        5 years ago

        Fowmy 

        when I am applying this. It is giving me all 1.