Chart with last 4 weeks' data and secondary chart with just last week's data
Hello! This is my first forum post so please be understanding if I post too much info, I want to be 'easy' to help 🙂 I am trying to show 4 weeks of data in a chart, which is easy, but on the same power bi page in a different chart, show the most recent week worth of data too. I have the data automatically uploading from a database source. The data I have currently looks like this in my query, with the current chart showing the equipment name on x axis, and the OEE percentages on Y. There is a slider that is linked to Shift ISO column so that the last 4 weeks of data can be displayed. Is there any way to make a chart that only shows the last week's worth of data based on the time of accessing the power bi? thank you!
Need a formula to produce overall average per week of month
It's Monday and the answer is probably as simple as 1 + 1 = 5 (ha ha) but I can't figure it out: In my Date table, I have a column with the Week of the Month (according to how we break them down) for each day, I have the total number of months for which I have data for each of those weeks and sum count of all the tickets for each of those week blocks: I need a formula that will give me the AVERAGE for each of those week blocks vs. the Sum of them. So, for example, instead of seeing 42,298 for W1, I'd want to see 7,049. These will ultimately be put on line axis of a cluster chart along with other data (the counts for each week block of the current month and previous month so we can compare how the last 2 months compare with the cumulative average for all months). Note that depending on the day of the month, not every week-block will be based on the same number of months (see W4). What totally obvious (probably) formula would I use to produce that? If you are willing to go one step further, ultimately what I'll need are the weekly block average that will still respect any filters/slicers applied to it EXCEPT my selected date range filter. The other data that is in the clustered chart must still respect the date filters applied...just the line for this data should ignore that (so I can't use the Edit Interactions on it).Dynamic 13 weeks based on WEEK SELECTION [DD-MM-YY]
Hi Power BI Community I'm trying to create a dynamic 13 weeks selection based on week DD-MM-YY which should dynamically populate 13 weeks data instead of individual selection. I check the earlier solved DAX query which is mostly based on 13-weeks selection. https://community.powerbi.com/t5/Community-Blog/Week-Is-Not-So-Weak-WTD-Last-WTD-and-This-Week-vs-Last-Week/ba-p/1051123. Thanks [@AmitChandak] Currently, I'm using this DAX which is partially doing the job, where I've to select the whole 13 weeks to achieve the desired output, instead, I need one single selection and it should populate the previous 13 weeks data before that without selecting prior 13 week value in the slicer. In my use case, I'm using Line and Clustered Column Chart that should dynamically change e.g. when I select Week Commencing e.g. 13-12-2020 (Please note I'm using DD-MM-YY not Week number), it should pull data from 13-12-2020 to 20-09-2020 or if I select 20-12-2020 the data range should be till 27-09-2020 so that I can see how my last 13 sales are doing. As shown in sample datasets and Line https://drive.google.com/file/d/1xk1xlvWiFcGTUH_8X_1R5OwwARVm11NP/view?usp=sharing and Clustered Columncharts. I've attached sample data, DATE table, and DAX measure formula Please help. Many Thanks
