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 on every 10 minutes one graph to another graph in clockwise. Please suggest

 

eg: same day last week 

 

 

 

 

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

4 Replies

  • 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