Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

Assistance Needed on G/R Table – Total Column.

Hi Team, Good Morning!! I hope you're all doing well. I have a table like below:   G/R Jan-25 Feb-25 Mar-25 Apr-25 May-25 Total Sales 380955958.5 306713898.6 306383067.8 28380...
Need Help
  • pankajnamekar25's avatar
    pankajnamekar25
    1 year ago

    MoM_Display =

    VAR _MoM = [MoM]  -- your existing MoM calculation

    RETURN

    IF(

        ISINSCOPE('Date'[MonthYear]),  -- or the relevant column used on Columns in Matrix

        _MoM,

        BLANK()  -- or return a custom text "-" with formatting

    )

    Thanks,
     Pankaj Namekar | LinkedIn

    If this solution helps, please accept it and give a kudos (Like), it would be greatly appreciated.

pankajnamekar25's avatar
pankajnamekar25
Super User
1 year ago

MoM_Display =

VAR _MoM = [MoM]  -- your existing MoM calculation

RETURN

IF(

    ISINSCOPE('Date'[MonthYear]),  -- or the relevant column used on Columns in Matrix

    _MoM,

    BLANK()  -- or return a custom text "-" with formatting

)

Thanks,
 Pankaj Namekar | LinkedIn

If this solution helps, please accept it and give a kudos (Like), it would be greatly appreciated.

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Dear pankajnamekar25 ,  

Thank you for your prompt response. It is working as expected.


Best regards,
Vannur Vali