Forum Discussion

nagoor's avatar
nagoor
Helper III
7 years ago
Solved

showing 2 different dates dynamically

Hi Guys,   Could you suggest an idea to plot the graph like this in a dynamic manner in the date filed? it needs to adjust automatically  based on the current day  2) auto toggling between graphs ...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    Hi nagoor,

     

    You can try to use following formula to get 'same day last week' average of available amount:

    Measure =
CALCULATE (
    AVERAGE ( 'raw data'[Availability] ),
    DATEADD ( 'raw data'[Period], -7, DAY ),
    VALUES ( 'raw data'[Hrs] )
)

     

     

    Regards,

    Xiaoxin Sheng

nagoor's avatar
nagoor
Helper III
7 years ago

hi Anonymous 

 

Thanks for your response, i have attached the sample data. please have a look and provide your comments. 

 

Sample Data

 

Thanks,

nagoor

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi nagoor,

 

You can try to use following formula to get 'same day last week' average of available amount:

Measure =
CALCULATE (
    AVERAGE ( 'raw data'[Availability] ),
    DATEADD ( 'raw data'[Period], -7, DAY ),
    VALUES ( 'raw data'[Hrs] )
)

 

 

Regards,

Xiaoxin Sheng

  • nagoor's avatar
    nagoor
    Helper III
    7 years ago

    Anonymous

     

    Thanks for your support, got it now.. :-)