Help with DAX measures

[kartiklal7]

Hi All, 

I need some help with a couple of dax measures. 

I have an Opportunities table with the following fields. I also have a Calendar where the Date is joined to the ResolutionDate in the Opportunities Table. 

In my report page I also have Year and Quarter slicers.

I need two dax measures with the following conditions

Measure A: 

Calculate AnnualRenewalAmount when Sales Stage = "Closed Sales", ExistingExpiryDate is in selected quarter and resolutiondate is in the selected or prior to the selected quarter. ResolutionDate also cannot be blank or in the future. 

Measure B:

Calculate AnnualRenewalAmount when Sales Stage = "Closed Sales". If the ExistingExpiryDate is prior to the selected quarter, then resolutiondate will be in the selected quarter. If the ExistingExpiryDate is in the selected quarter, then ResolutionDate shall be in the selected or prior to the selected quarter. ResolutionDate cannot be in the future. 

[v-zhangti]

Hi, @kartiklal7 

Can you provide some sample data or simple pbix files? Sensitive information can be removed in advance. What kind of expected results do you expect? You can also show it with pictures.

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[kartiklal7]

Any suggestions?