Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

HOW TO SHOW MTD REMAINING VALUE?

Hi,

 

I want to total Month Goal - with Current date GP = Show MTD Remaining Amount

 

I try this but didn't work 

[TOTALMONTHSUM]-[MTD SBI GP]
Need Help

1 Reply

  • v-lili6-msft's avatar
    v-lili6-msft
    Icon for Community Support rankCommunity Support
    7 years ago

    hi, Anonymous 

    Could you please share your sample pbix file and expected output?

    Why [TOTALMONTHSUM]-[MTD SBI GP] odesn't work? The screenshots is a excel format, we couldn't find the reason of it.

     

    Best Regards,

    Lin