I have a log table that shows me the order log per day. This table contains one measure and one column which are:
Column Date:
AllDates = CALENDAR(MIN('LOG'[DTH_INCLUI_LOG]);MAX('LOG'[DTH_INCLUI_LOG]))
Measure LogStatus:
VAR CurrentDate = SELECTEDVALUE(AllDates[Date])
VAR MaxDate = CALCULATE(MAX('LOG'[DTH_INCLUI_LOG]);'LOG'[DTH_INCLUI_LOG] <= CurrentDate+1)
RETURN CALCULATE(MAX('LOG'[VLR_NOVO]); 'LOG'[DTH_INCLUI_LOG] = MaxDate)
This column and measure was this table:
enter image description here Now I need to create a new table that counts the amount of each status per day. Example: On day one got 45 status A, 75 status P, 35 status Q (...)
How do I achieve this result?
