Forum Discussion

P_R's avatar
P_R
Frequent Visitor
7 years ago
Solved

SQL to DAX: Get SalesPerson Region on a specific date into a measure

I have been working in SQL and SSRS for several years now but i am new to PowerBI. I am having difficulty creating a measure. I have below tables: 1. Order 2. SalesPersonTeam In Order table i have...
Need Help
  • v-juanli-msft's avatar
    v-juanli-msft
    7 years ago

    Hi P_R

    Create relationships as below, reference here

     

    Create measures in SalesPersonSalesTeam table

    Start = MAX([StartDate])

end = IF(MAX([ExpirationDate])=BLANK(),DATE(2999,12,31),MAX([ExpirationDate]))

Measure = CALCULATE(SUM('Order'[amount]),FILTER('Order',[datestamp]>=[Start]&&[datestamp]<=[end]))

     

    Best Regards

    Maggie

     

v-juanli-msft's avatar
v-juanli-msft
Icon for Community Support rankCommunity Support
7 years ago

Hi P_R

Create relationships as below, reference here

 

Create measures in SalesPersonSalesTeam table

Start = MAX([StartDate])

end = IF(MAX([ExpirationDate])=BLANK(),DATE(2999,12,31),MAX([ExpirationDate]))

Measure = CALCULATE(SUM('Order'[amount]),FILTER('Order',[datestamp]>=[Start]&&[datestamp]<=[end]))

 

Best Regards

Maggie