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

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi nagoor,

 

#1, Yes, it is possible to create a 'same day last week' graph line in line chart, can you please share some sample data for test and coding formula?

 

#2, Nope, I don't think it is possible to achieve this requirement.

 

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.. :-)