Forum Discussion
dax and weeky
I have got this table where I have calculated weeks for different dates . Day of the week here start from wednesday and ed on tuesday. Problem I am facing is in slicer and weekly percentage change for each ticket. There are different type of tickets. I want to have function for weekly percentage change based on their respective dates like closure tickets percentage change should be based on closure week for each ticket type, secondly I want to know is their any way that we can use one slicer for week where we can use date for each ticket type in just one slicer. I have made this dashboard but problem is it is based upon created date column while values for all other dates are different so I want to know is their anyway that we can use one slicer date based week slicer for all the ticketing type?
4 Replies
- amitchandak
Super User
Hamdan1234 , refer if two of my blog can help. One is week of Wed -tue and other on WOW
Any Weekday Week - Start From Any day of Week
https://community.powerbi.com/t5/Community-Blog/Any-Weekday-Week-Decoding-Date-and-Calendar-2-5-Power-BI-Turning/ba-p/1187482Power BI — Week on Week and WTD
https://medium.com/@amitchandak.1978/power-bi-wtd-questions-time-intelligence-4-5-98c30fab69d3
https://community.powerbi.com/t5/Community-Blog/Week-Is-Not-So-Weak-WTD-Last-WTD-and-This-Week-vs-Last-Week/ba-p/1051123
https://www.youtube.com/watch?v=pnAesWxYgJ8- Hamdan1234
Helper III
can you please give details about dates how to use all dates at one slicer?
- amitchandak
Super User
Hamdan1234 , for more than one date you need to have common date table and use userelationship
- Greg_Deckler
Community Champion
Hamdan1234 - Can you post data as text?
This might help:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Open-Tickets/m-p/409364