Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
4 years ago

See: Unfiltered dashboards for selecting time intelligence

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

4 Replies

  • speedramps's avatar
    speedramps
    Icon for Super User rankSuper User
    4 years ago

    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's avatar
      Syndicate_Admin
      Icon for Administrator rankAdministrator
      4 years ago

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

      • v-chenwuz-msft's avatar
        v-chenwuz-msft
        Icon for Community Support rankCommunity Support
        4 years ago

        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.

  • speedramps's avatar
    speedramps
    Icon for Super User rankSuper User
    4 years ago

    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 !