Comparar Períodos Distintos

[Vilmar]

Olá

Preciso comparar periodos distintos no mesmo visual, porem não estou conseguindo.

PBIX aqui 

Esta medida dá certo:

Vendas1 = 
CALCULATE (
    [Total],
    ALLSELECTED ( dcalendario1 ),
    DATESMTD ( dcalendario1[Date] ),
    USERELATIONSHIP ( dcalendario1[Date], fSboprodql[DataPedido] ),
    USERELATIONSHIP ( dcalendario1[Date], 'fSboprodcd'[DataPedido] ),
    dStatus[Status Agrupador] = "FATURADO"
        || dStatus[Status Agrupador] = "CARTEIRA",
    'fSboprodcd'[OperacaoFiscal] = "VENDA",
    fSboprodql[OperacaoFiscal] = "VENDA"
)

Esta medida não dá certo:

Vendas2 = 
CALCULATE (
    [Total],
    ALLSELECTED ( dCalendario1 ),
    DATESMTD ( dcalendario1[Date] ),
    USERELATIONSHIP ( dCalendario2[Date], fSboprodql[DataPedido] ),
    USERELATIONSHIP ( dCalendario2[Date], 'fSboprodcd'[DataPedido] ),
    dStatus[Status Agrupador] = "FATURADO"
        || dStatus[Status Agrupador] = "CARTEIRA",
    'fSboprodcd'[OperacaoFiscal] = "VENDA",
    fSboprodql[OperacaoFiscal] = "VENDA"
)

[amitchandak · Accepted solution]

@Vilmar , refer if my video or blog can help on this

How to use two Date/Period slicers :https://www.youtube.com/watch?v=WSeZr_-MiTg

blog : https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601

[v-xulin-mstf · Accepted solution]

Hi @Vilmar,

You are dragging and dropping the 'Dia' of the table 'dCalendario1' in the table visual. It is not part of the 'Vendas2' date filter and I have added a new 'Dia' column to table 'fSboprodcd'.

Here is the output:

Please try the attached demo.

If you still have some question, please don't hesitate to let me known.‌‌

Best Regards,

Link

Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution. Really appreciate!

[Vilmar]

@v-xulin-mstfe @amitchandak as dicas de vocês me ajudou a criar uma terceira tabela calendario, fazer o relacionamento entre as duas tabelas fatos e colocar ela no visual. Agora deu certo. Obrigado!!

[amitchandak · Accepted solution]

@Vilmar , refer if my video or blog can help on this

How to use two Date/Period slicers :https://www.youtube.com/watch?v=WSeZr_-MiTg

blog : https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601