last week

2 Topics

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!
Solved
Anonymous
3 years ago Place DAX Commands and Tips
550Views
0likes
1Comment
How to get last week value per each category
Hi All.. I want to return the last week value per category. Here are the data and the example: WeekNo Value Category 1 1 A 2 2 A 3 1 A 1 2 B 3 1 B I want to create a table that shows the selected week value and the n-1 selected week value. I'm currently using this measure: LastWeekValue = calculate( sum('table'[Value]), FILTER(ALL('table'), 'table'[WeekNo]= SELECTEDVALUE('table'[WeekNo]) - 1)) And here's the result of the measure: Assuming that the selected week no is 3 Category SelectedWeekValue LastSelectedWeekValue A 1 2 B 1 2 The measure is showing the right sum of value on previous week. However, the value is showing the same value on each category. (Category B shows value = 2, eventhough that it actually has no value on week 2). Here's the desired output looks like : Assuming that the selected week no is 3 Category SelectedWeekValue (week no 3) LastSelectedWeekValue (week no 2) A 1 2 B 1 0 Please help me to solve this. Thank you so much!!!!!
Solved
NKBI2022
3 years ago Place Desktop
736Views
0likes
1Comment