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

Icey's avatar
Icey
Community Support
5 years ago

Hi beast314 ,

 

How about this?

Measure 2 =
IF (
    ISFILTERED ( 'Table'[Date].[Day] ),
    [Quant30],
    IF ( ISFILTERED ( 'Table'[Date].[Month] ), AVERAGEX ( 'Table', [Quant30] ) )
)

 

 

Best Regards,

Icey

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • beast314's avatar
    beast314
    Frequent Visitor
    5 years ago

    No. It not working. 

    • Icey's avatar
      Icey
      Community Support
      5 years ago

      Hi beast314 ,

       

      What exactly does not meet your requirements? Could you show me more details?

       

       

      Best Regards,

      Icey

      • beast314's avatar
        beast314
        Frequent Visitor
        5 years ago

        It's showing me a complete blank on that.