Forum Discussion

kartiklal7's avatar
kartiklal7
Frequent Visitor
4 years ago

Help with DAX measures

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. 

 

 

 

 

 

Need Help

2 Replies

  • v-zhangti's avatar
    v-zhangti
    Icon for Community Support rankCommunity Support
    4 years ago

    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.