Sum interval considering many filters
Hello everyone, I have been here a time ago to solve a problem within this same topic, the thing is, the solution was complete but i found out that one other thing was needed. I need the following dax code, not to consider all the order as "out", when the sum of items reach the total of stok available, but, i need to test others orders to see if the amount of the stok can be used still, axample: i have orders 333, 444 and 555 with the item bbb, with quantities 2, 30 and 5, the stok is 10 for this item, the actual code, tests the stok to the orders and the result is : available, ou, out; but i need the result to be: available, out, available.. of course, following the same logic of the earlier order num, only inside of the range date i select. When i select the date 01/03/25 to 01/03/25, the only orders that have in this date are the in the example.. Measure = VAR _date = CALCULATE(MAX('Table date'[date]), ALLSELECTED('Table date')) VAR _quantity = CALCULATE( SUM('Table orders'[quantity]), FILTER( ALLSELECTED('Table orders'), [Item] = MAX('Table orders'[Item]) && [date] <= MAX('Table orders'[date]) && [Order num] <= MAX('Table orders'[Order num]) -- Considera o número do pedido ) ) VAR _stock = CALCULATE( SUM('Table stock'[quantity]), FILTER( ALL('Table stock'), [item] = MAX('Table orders'[Item]) ) ) VAR _result = IF(_quantity <= _stock, "available", "out") RETURN IF(ISBLANK(_quantity), BLANK(), _result) Thankyou a lot allready!
Calendar Software by MAQ: Visual Customizations
I am a new user to MAQ Calendar application. So far so good, but the end user has requested some customizations that I have not been able to locate within the visualization settings. 1. Can the "Time" data be removed from the LIST view so it only reads the date and event? 2. I have identified how to REMOVE the week & day views- but can you make LIST view the DEFAULT? 3. Can you set the LIST view to START on Today's date vs starting on the first day of the month? Currently create a need to do a lot of scrolling to get to the current day if later in the month. 4. Can you prioritize which events appear first in a given day on the calendar view? Any guidance would be greatly appreciated! Thank you!
Customize List View
Hello, is there any way to customize the List View or create an custom List View for End Users? The 'Size', 'Modified' date and 'Modified by' columns are not really interesting for users and i would like to remove them. On the other hand a "Last Run" column for scheduled reports would be interesting. Best regards
