cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

DAX Week and Month as tabs

Hi Experts,

I'm having a situation where need to calculate a KPI ( performance over a week and performance over a month) which should be available as a selection in the dashboard. Weekly KPI is 1350 records processed per person and I'm also not sure how to calculate for month ( this requires no of working days by 270 records processed per day). 

team size is 5 persons and individual graphs to be developed.

 

Data that i have is Total records, person name and date table;

 

1. what kind of a graph will be suited for this requirement?

2. DAX Calculation of  weely and monthly KPI?

3. How to design the switching between week and month in one single report ( Dax )?

 

Thank you for your support.

Regards,

Laz

 

1 ACCEPTED SOLUTION

Accepted Solutions
Anonymous
Not applicable

Re: DAX Week and Month as tabs

This issue is now resolved. Thanks for all your answers. Couldn't assign any points as this was resolved internally.

View solution in original post

4 REPLIES 4
Community Support Team
Community Support Team

Re: DAX Week and Month as tabs

Hi @Anonymous ,

 

Firstly, I think the KPI visualization is the best way to display your requirement. There  is a document  you can reference.

3.jpg

And then, can you please post some sample data and the expected output. I want to know how you calculated the KPI.

Finally, what effects of switching between week and month do you want ?  Do you want to filter the measure of weekly and monthly using a slicer?

 

Best Regards,

Xue Ding

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

Anonymous
Not applicable

Re: DAX Week and Month as tabs

Hi @v-xuding-msft 

Thank you for your prompt reply.

I'm still learning about the Switch function but still couldn't get the hang of it. I'm using following DAX statement to switch between Week and Month. What I need is something like when i select Week, month figures should blank out and vise versa. 

DynamicSelection = 
          SWITCH(true(),
                [Selection] = 1,'Planning Time'[Weekly KPI],
                [Selection] = 2,'Planning Time'[Monthly KPI],BLANK()
)

Selection is nothing but a table which i manually created which has an Index 1,2 and Week and Month respectively. Then i'm using two measures to calculate week and month. At present moment when i click on week or month i can see on top left of the visualisation ( which is a Gauge) refresh icon appears and disappear but nothing else happens.

 

Please advise what's the best practice behind creating the Switch ? is Toggle is same as switch or different? 

Thanks again

Regards

LW

Community Support Team
Community Support Team

Re: DAX Week and Month as tabs

Hi @Anonymous 

 

Based on your scenario, there is a similar thread you can reference. If you have any issue, please  post sample data and the excepted output.

https://community.powerbi.com/t5/Desktop/Dynamic-change-in-X-Axis/td-p/86167

 

Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490 

 

Best Regards,

Xue Ding

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

Anonymous
Not applicable

Re: DAX Week and Month as tabs

This issue is now resolved. Thanks for all your answers. Couldn't assign any points as this was resolved internally.

View solution in original post

Helpful resources

Announcements
New Topics Started Badges Coming

New Topics Started Badges Coming

We're releasing new versions of the badge that everyone's talking about. ;) Check your inbox for notifications.

MBAS 2020

Save the new date (and location)!

Our business applications community is growing—so we needed a different venue, resulting in a new date and location. See you there!

Difinity Conference

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Top Kudoed Authors (Last 30 Days)