Contar linhas no período entre datas
Olá, poderiam ajudar com essa situação. Tenho essa pequena tabela para exemplificar. Preciso contar as linhas, para isso uso a COUNTA, e até aí tudo certo, agora vem o problema: Imagina que estou executando um filtro no Dashboard com a data do dia 15/04/2022. Preciso que ele conte os itens com os ID's 3, 5, 6. (total de 3) A situação é contar os itens no estoque nessa data (15/04/2022). Então não posso considerar se entrou ou saiu dia 15, preciso considerar o período "ENTRE" das colunas dtatende e dtsaida. Se alguém puder ajudar, serei grato. anexo está o fixeiro
DAX in building Rolling 4 Week Average
Hi, I need help in building 4 week rolling average for "Net Change in Price and Cost" with below sample data Change in Price, Change in Cost and Net Change in Price and Cost are all 3 measures. Net Change in Price and Cost = Change in Price - Change in Cost I do have separate date table and the above data shows weekly data and my report has Invoice Date as Filter. I need to calculate rolling 4 week average, here the tweak is that for first week start date 12/07 rolling average should be same while for next 12/14 it should (-4.80% + 0.18%)/2 = -2.31% for 12/21 it should be (-4.80% + 0.18% - 0.04%)/3 = -1.55% for 12/28 it should be (-4.80% + 0.18% - 0.04% -0.65%)/4 = -1.33% for 01/04 it should be (0.18% - 0.04% -0.65% +1.03%)/4 = 0.13% as shown below I have created below DAX but its not working as expected Net Change in Price and Cost 4 Wk Rolling Avg = var start_day = MIN('Date'[Week Start Date])-21 var end_day = MAX('Date'[Week Start Date]) return CALCULATE([Net Change in Price and Cost], DATESBETWEEN('Date'[Week Start Date],start_day,end_day), REMOVEFILTERS('Date'[Week Start Date]))/CALCULATE(DISTINCTCOUNT('Date'[Week Start Date]),DATESBETWEEN('Date'[Week Start Date],start_day,end_day),REMOVEFILTERS('Date'[Week Start Date])) Can someone help me on this??
Need help quick! Percent On Time measure not working with filters?
I have a whole page dedicated to exploring our products that have shipped late, meaning there is a page filter for [On Time Ship]="False". I also have a measure to calculate the % on time for each product. The formula is: % On Time = CALCULATE(DISTINCTCOUNT(CVD_OTD_FTMS_IV[Reference Number]),CVD_OTD_FTMS_IV[On Time Ship]=true(),REMOVEFILTERS(CVD_OTD_FTMS_IV[On Time Ship]))/CALCULATE(DISTINCTCOUNT(CVD_OTD_FTMS_IV[Reference Number]),REMOVEFILTERS(CVD_OTD_FTMS_IV[On Time Ship])) where [Reference Number] is the unique identifier for someone's ordered item. This measure isn't working the way I want it to and I am not sure why. The count of late items works as expected, but the total count (or denominator in my % on time measure) doesn't show what I expect unless I remove the page filter for [On Time Ship]="False". I don't know why this would be the case since I have a RemoveFilters command in the measure formula?? For example, the product below shows this with the page filter applied: and the same product without the page filter applied: The real total count is 277 for this product. Why is it only 55 when the page filter is applied?? I need help rather quickly, please and thank you!!
compare two columns
I have Global POL table, trying to Compare the two column CBL and CBL LOCAL .If both column value same its return true. if values not match and both column blank its return False. i have tired the below measure . True/False = IF ( 'Global POL'[CBL]= 'Global POL'[CBL Local], "True", "False" ) INPUT : ID CBL CBL LOCAL 122 MS14-CA04CAS002 MS14-CA04CAS002 123 MS14-CA04CAS004 MS14-CA04CAS004 124 MS14-CA04CAS004 MS14-CA04CAS002 125 EXPECTED OUTPUT: ID CBL CBL LOCAL TRUE/FALSE 122 MS14-CA04CAS002 MS14-CA04CAS002 TRUE 123 MS14-CA04CAS004 MS14-CA04CAS004 TRUE 124 MS14-CA04CAS004 MS14-CA04CAS002 FALSE 125 FALSE
