Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 the visual. Any help would be appreciated.
@Anonymous
You may take a look at the links below.
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.
First of all, remove the filter clause and check if it working or not. Then put them one by one and check which filter is causing it.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
95 | |
76 | |
65 | |
51 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |