See: Unfiltered dashboards for selecting time intelligence

[Syndicate_Admin]

Good afternoon, I hope you are well.

I need to make a dashboard with KPIs affected by time but my user is not going to select them.

For example, I need to show the total sales per hour, day, week, month and accumulated.

For example: If I want to know the sales of the previous day, I add the sales and select the date of yesterday and that's it. But now I can't find a way to do it or the right material to help me solve this problem.

Someone from this community can help me?

Thank you

Best regards

Ana

[speedramps]

Polite reminder.

Please watch the video and use the day offset to get the values for previous day

https://www.youtube.com/watch?v=XjVLaVLluYE

Remeber we are unpaid volunteers.

Click the thumbs up and accept as solution button. 

One question per ticket please. If you need to extend your request then please raise a new ticket.

You will get a quicker response and each volunteer solver will get the kudos they deserve. Thank you !

[speedramps]

Do this training and all subsequent calandar training (is all free)

Click here to begin learning 

Thanks for reaching out for help.

I have helped you, now please help me by giving kudos.

Remeber we are unpaid volunteers.

Click the thumbs up and accept as solution button. 

One question per ticket please. If you need to extend your request then please raise a new ticket.

You will get a quicker response and each volunteer solver will get the kudos they deserve. Thank you !

[Syndicate_Admin]

Thank you!, but it does not show me how to calculate the total sales of the previous day.-

[v-chenwuz-msft]

Hi @Syndicate_Admin ,

Maybe you can try DATEADD() function.

some measures like this:

CALCULATE( SUM('Table'[sales]), DATEADD( 'Date'[Date] , -1 ,DAY )) // previous day

CALCULATE( SUM('Table'[sales]), DATEADD( 'Date'[Date] , -1 ,MONTH )) // previous month

Best Regards

Community Support Team _ chenwu zhu

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