Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Opportunity created in current month

Dear All,   I've the below sample data set as shown below. This fact table linked to Date dimension based on closeddate. I need to calcuate the belwo metrics.   New opportunity created = sum of ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi, I tried to use the below expression but nothig is showing the table.

 

New Opportunities Created = CALCULATE(sum(Opportunities[TOTALOPPORTUNITYQUANTITY]),Opportunities[ISCLOSED]="false",USERELATIONSHIP(Opportunities[CREATEDDATE],'Calendar'[Date]))
Washivale's avatar
Washivale
Icon for Resolver V rankResolver V
7 years ago

Hi Anonymous ,

 

let me know from which table you have selected date column in matrix to see the results, also let me know format for created date column and isclosed column

 

 

Regards,

washivale