Forum Discussion

RH205's avatar
RH205
Icon for Helper I rankHelper I
1 year ago
Solved

Calculate measure based on startdate from dimension table

hi, hope somebody loves a challenge;)   we would like to sum two measures based on company startdate.. 1. revenue = CALCULATE([revenue] ,FILTER(ALL('Date'), 'Date'[Date] <= MAX('Date'[Date])) 2. ...
Need Help
  • v-saisrao-msft's avatar
    v-saisrao-msft
    1 year ago

    Hi RH205,

    Thank you lbendlin, for your insights.

    I reproduced your issue with sample data and was able to create the issue in Power BI. I've attached the PBIX file for your reference.

     

    Thank you.

v-saisrao-msft's avatar
v-saisrao-msft
Icon for Community Support rankCommunity Support
11 months ago

Hi RH205,

Have you had a chance to review the solution we shared earlier? If the issue persists, feel free to reply so we can help further.

 

Thank you.