topic Re: Variação dia vs dia in DAX Commands and Tips

Variação dia vs dia

raffa_pintto1 — Tue, 19 Sep 2023 18:03:34 GMT

Boa Tarde

Estou fazendo esse calculo dax no qual tenho uma base de dados onde alguns dias da semana tem o preenchimento com dados e outros não. Preciso que quando não tiver dados eu pego os dados do dia anterior. Exemplo nos meus dados

dia

15/09

14/09

13/09

12/09

10/09

09/09

08/09

Estou no dia 12/09 não tenho dados do dia 11/09 e 10/09 então no meu meu dax está dando 100% eu preciso que ele pegue o dados do dia 09/09 que seria o ultimo dia que tenho dados e faça variação percentual

Re: Variação dia vs dia

lbendlin — Thu, 21 Sep 2023 01:52:00 GMT

You do that using disconnected tables.

Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot). Leave out anything not related to the issue.
https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.

https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

Re: Variação dia vs dia

Anonymous — Thu, 21 Sep 2023 09:50:12 GMT

Hi raffa_pintto1 ,

Here I create a sample to have a test.

Measure:

M_ULTIMO km = VAR _STEP1 = ADDCOLUMNS ( ALL('Calendar'), "km", CALCULATE ( SUM ( 'Table'[ULTIMO km] ), USERELATIONSHIP ( 'Table'[Data Brev], 'Calendar'[Date] ) ), "km last day", CALCULATE ( SUM ( 'Table'[ULTIMO km] ), FILTER ( 'Table', 'Table'[Data Brev] = EARLIER ( 'Calendar'[Date] ) - 1 ) ) ) VAR _STEP2 = ADDCOLUMNS ( _STEP1, "New km", VAR _LASTNOTBLANK = MAXX ( FILTER ( _STEP1, [Date] <= EARLIER ( [Date] ) && [km] <> BLANK () ), [Date] ) VAR _KM = SUMX ( FILTER ( _STEP1, [Date] = _LASTNOTBLANK ), [km] ) RETURN _KM ) RETURN SUMX(FILTER(_STEP2,[Date] =MAX('Calendar'[Date])),[New km])

M_D X D = VAR _STEP1 = ADDCOLUMNS ( ALL('Calendar'), "km", CALCULATE ( SUM ( 'Table'[ULTIMO km] ), USERELATIONSHIP ( 'Table'[Data Brev], 'Calendar'[Date] ) ), "D X D", CALCULATE ( SUM ( 'Table'[ULTIMO km] ), FILTER ( 'Table', 'Table'[Data Brev] = EARLIER ( 'Calendar'[Date] ) - 1 ) ) ) VAR _STEP2 = ADDCOLUMNS ( _STEP1, "New DXD", VAR _LASTNOTBLANK = MAXX ( FILTER ( _STEP1, [Date] <= EARLIER ( [Date] ) && [D X D] <> BLANK () ), [Date] ) VAR _DXD = SUMX ( FILTER ( _STEP1, [Date] = _LASTNOTBLANK ), [D X D] ) RETURN _DXD ) RETURN SUMX(FILTER(_STEP2,[Date] =MAX('Calendar'[Date])),[New DXD])

M_%Mom dia = DIVIDE([M_ULTIMO km] - [M_D X D],[M_D X D])

Result is as below.

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.