The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
First 90 Days = CALCULATE(SUM('dpmgr vwJMWebSalesOpportunitiesProduction'[MRRNormalized$]), 'dpmgr vwJMWebSalesOpportunitiesProduction'[Consolidated Department] <> "Existing Clients", 'dpmgr vwJMWebSalesOpportunitiesProduction'[CloseDate] >= *******
Where I have the ****** I am trying to write another, different date column. There are relationships between the two tables, but I'm not sure why it won't let me select a date.
Every client has a "First Execution Date" and I added a column "First Execution DAte + 90 DAys". I need to determine the SUM of MRR$ where the Close Date >= "First Execution Date + 90 Days"
Solved! Go to Solution.
Try to include FILTER(), somehting like
First 90 Days = CALCULATE(SUM('dpmgr vwJMWebSalesOpportunitiesProduction'[MRRNormalized$]),
FILTER('dpmgr vwJMWebSalesOpportunitiesProduction','dpmgr vwJMWebSalesOpportunitiesProduction'[Consolidated Department] <> "Existing Clients", 'dpmgr vwJMWebSalesOpportunitiesProduction'[CloseDate] >= *******)
It should allow to enter date and if relationships are correct should work. Or at least tell you what it doesn't work 🙂
Hi,
Share the link from where i can download your file.
Try to include FILTER(), somehting like
First 90 Days = CALCULATE(SUM('dpmgr vwJMWebSalesOpportunitiesProduction'[MRRNormalized$]),
FILTER('dpmgr vwJMWebSalesOpportunitiesProduction','dpmgr vwJMWebSalesOpportunitiesProduction'[Consolidated Department] <> "Existing Clients", 'dpmgr vwJMWebSalesOpportunitiesProduction'[CloseDate] >= *******)
It should allow to enter date and if relationships are correct should work. Or at least tell you what it doesn't work 🙂