showing 2 different dates dynamically

[nagoor]

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 

 

[v-shex-msft]

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]

hi @v-shex-msft 

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

Sample Data

Thanks,

nagoor

[v-shex-msft · Accepted solution]

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]

@v-shex-msft

Thanks for your support, got it now.. 🙂