Max Week in Month
Hello All! Hoping someone can help! I have data set like this.. each week there is a new snapshot taken. In a matrix I am showing the number of users by location by month. As you can see in the snapshot for 2/11/2021 we have 7 users, 1 in Germany and 6 in Denmark. Problem is what I want to show is the values for the last week in that month. Currently what i get is the output in the first table i.e. 1 in Germany and 1 in Denmark, whereas what I want is the position as of 16/11/2021... the measure needs to be able to always calculate based on the last week of data for that month... so when we add a snapshot for the following week, 23/11/2021, it would use this in instead. I have a date table. Cheers Andy
Inner Filter and Outer Filter not working
hi folks, I am trying to do a dual filter on a table, running DirectQuery mode, which doesnt seem to work as I hoped - hoping someone here has better ideas. Example table: Outcome date Outcome 1 Outcome Show 4/5/2019 56 700 4/9/2019 78 800 5/23/2019 250 900 7/30/2019 79 1000 7/30/2019 80 1100 what I am trying to do is a table that shows: Outcome date Outcome Show 7/30/2019 1100 with this Measure: Outcome Filter Measure = SUMX( FILTER( FILTER( 'Outcome Table', 'Outcome Table'[Outcome Date]=MAX('Outcome Table'[Outcome Date]) ), 'Outcome Table'[Outcome 1]=MAX('Outcome Table'[Outcome 1]) ), 'Outcome Table'[Outcome Show]*1 Which ends up showing up blank - because the outer filter doesnt seem to work - ie. DAX views them not as sequential filters, but as "AND" filters. So if dont do the second filter, and just filter for MAX Outcome Date, I end up with first row of Max date, showing 1000, while I want to have the table filtered first down to the Latest date availiable, then within that subset, look for the largest Outcome 1 value, then only show resulting row. Thanks all!
