Forum Discussion
TotalMTD not returning a value
Hello, I would like to show MTD Net Sales and copied a similar DAX formula that works for another page. I've adjusted to pull TotalMTD. There are no errors showing, however, the field is blank in t...
Hi,
This isn't how it should be. Create a Calendar Table and build a relationship from the Close Date column to the Date column of the Calendar Table. In the Calendar Table, extrac the Month Name by using this calculated column formula: Month = FORMAR(Calendar[Date],"mmmm"). Build a slicer from the Month column of the Calendar Table and select any Month. Try this measure
=CALCULATE(SUM(Full_Data[opportunity.Net_New_Sales__c]),Full_Data[opportunity.IsClosed] = TRUE,Full_Data[opportunity.StageName]= "Closed Won")
Hope this helps.