Forum Discussion
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...
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 | LinkedInIf this solution helps, please accept it and give a kudos (Like), it would be greatly appreciated.
Hi Anonymous
You can use a conditional dynamic format string:
IF ( NOT ( ISINSCOPE ( Dates[Month and Year] ) ), "-", "#,0" )