Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Dynamatic calculation based on slicer

Hi,   I have been struggling with this question for a while. Here is what I was trying to accomplish: for a selected day, I will show the stats for that day and average stats for the same day of w...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Thanks, Jimmy.

 

Could you give me more details regarding how to use two slicers to filter out the current date in the second visual, and dynamatically select one year data to report on? Thanks,

 

Kathebrine

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Thanks for your response, Jimmy.

     

    The post you refered to is interesting, for sure I will be using that in the near future.

     

    But my question is more basic than that. I am struggling with calculating stats for same day of week in the past year giving a date. For example, if Novmeber 14, 2019 is selected, I should present average counts for all the Thursday within one year before Novmeber 14, 2019.  Below is what I got so far, but it doesn't give me exactly what I want. Thanks,

     

    Avg Shift Offered Calls =
    CALCULATE(
        AVERAGEX( VALUES( 'SUMMARY'[DT_DMN_ID]), [Call Offered]),
        DATESBETWEEN('Date'[CALENDAR_DATE],
    NEXTDAY(DATEADD(LASTDATE('Date'[CALENDAR_DATE]),-1,YEAR)),
            LASTDATE('Date'[CALENDAR_DATE]))
    )
     
    Thanks,
     
    Katherine
    • v-yuta-msft's avatar
      v-yuta-msft
      Icon for Community Support rankCommunity Support
      6 years ago

      Anonymous ,

       

      Generally, you need to create a week No. column to mark the week No. and 7 days in a week so that you can achieve the average count in a calculate expression.

       

      In addtion, if you can share some sample data and give the expected result, I can do further analysis.

       

      Community Support Team _ Jimmy Tao

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

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        v-yuta-msft 

         

        Could you let me know can I share the file with you? I can create some date in excel and load into Power BI, but how to post the file? I don't see an option to attach a file in the post section. Thanks,

         

        Katherine