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

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.