Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

data per week

hiii   i have created my sla per month now i want it to be showed as per week and i have a slicer that shows months. what i want to do is i need a slicer for weeks if i click on a week it should s...
Need Help
Show and Tell
  • v-zhenbw-msft's avatar
    v-zhenbw-msft
    5 years ago

    Hi Anonymous ,

     

    Do you want to create another measure that changes with Week?

    If yes, we can create the weeknum column and two measures to meet your requirement.

     

    1. Create week columns in Table.

     

    weeknum = WEEKNUM('Table'[Call Closed],2)
    weekName = "Week"&" "&WEEKNUM('Table'[Call Closed],2)

     

     

    2. Then we can create a slicer using the weekName column. And create two measures.

     

    selected week num = 
var _x = SELECTEDVALUE('Table'[weekName], "Week 1")
return
CALCULATE(MAX('Table'[weeknum]),FILTER('Table','Table'[weekName]=_x))

     

    RAW_SLA% _Week = 
CALCULATE (
    [RAW SLA%],
    filter (Query1,
        WEEKNUM(query1[Call Closed]) = [selected week num]
            
    )
)

     

     

    If it doesn’t meet your requirement, could you please show the exact expected result based on the table that you have shared?

    It will be helpful if you can show us the exact expected result based on the tables.

     

    Best regards,

     

    Community Support Team _ zhenbw

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

     

    BTW, pbix as attached.

v-zhenbw-msft's avatar
v-zhenbw-msft
Community Support
5 years ago

Hi Anonymous ,

 

Do you want to create another measure that changes with Week?

If yes, we can create the weeknum column and two measures to meet your requirement.

 

1. Create week columns in Table.

 

weeknum = WEEKNUM('Table'[Call Closed],2)
weekName = "Week"&" "&WEEKNUM('Table'[Call Closed],2)

 

 

2. Then we can create a slicer using the weekName column. And create two measures.

 

selected week num = 
var _x = SELECTEDVALUE('Table'[weekName], "Week 1")
return
CALCULATE(MAX('Table'[weeknum]),FILTER('Table','Table'[weekName]=_x))

 

RAW_SLA% _Week = 
CALCULATE (
    [RAW SLA%],
    filter (Query1,
        WEEKNUM(query1[Call Closed]) = [selected week num]
            
    )
)

 

 

If it doesn’t meet your requirement, could you please show the exact expected result based on the table that you have shared?

It will be helpful if you can show us the exact expected result based on the tables.

 

Best regards,

 

Community Support Team _ zhenbw

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

 

BTW, pbix as attached.