Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Time Intelligence at Graph Interactions %MoM, %YoY

Hello to you all, come to ask for assistance. Firstly, english isn't my mohter language, so i feel a bit confused if i'm being clear. I'll try to give many details as possible.   I'm having some ...
Need Help
Tips and Tricks
Tutorial Requests
v-chenwuz-msft's avatar
v-chenwuz-msft
Community Support
4 years ago

Hi Anonymous ,

 

The problem is the DATEADD(). When you select a month, the fact table imported to this page has been filtered only left the month you selected. the previous months have not been imported to the page. so there is no result.

 

Maybe you can use some measures like the following when on the condition you have selected one month.

 

VAR _s =
    SELECTEDVALUE( 'PERFIL_RENEG'[DT_BASE].[MonthNo] ) - 1
VAR __PREV_MONTH =
    CALCULATE(
        SUM( 'PERFIL_RENEG'[Saldo Ativo] ),
        FILTER( ALL( 'PERFIL_RENEG' ), MONTH( [DT_BASE] ) = _s )
    )
RETURN
__PREV_MONTH
when no selected, use your code is fine. combine these two conditions via if().
 

Best Regards

Community Support Team _ chenwu zhu

 

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