Forum Discussion

Ranjith_96's avatar
Ranjith_96
Icon for Helper I rankHelper I
3 years ago
Solved

difference between my two DAX

Hi Power BI Community, Please look at my image below , cumulative_sales = CALCULATE(SUM(Orders[Sales]),dim_date[Date]<= MAX(Orders[Order Date])) I am calculating cumulative sales, which is workin...
Need Help
Show and Tell
Tips and Tricks
  • amitchandak's avatar
    amitchandak
    3 years ago

    Ranjith_96 , as you are using order_date in measure same date has to be used in visual as you are using row context in measure 

    cumulative_sales1 = CALCULATE(SUM(Orders[Sales]),Orders[Order Date] <= MAX(Orders[Order Date]))

     

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
3 years ago

Ranjith_96 , as you are using order_date in measure same date has to be used in visual as you are using row context in measure 

cumulative_sales1 = CALCULATE(SUM(Orders[Sales]),Orders[Order Date] <= MAX(Orders[Order Date]))

 

  • Ranjith_96's avatar
    Ranjith_96
    Icon for Helper I rankHelper I
    3 years ago

    Thanks much amitchandak for your response.