Forum Discussion

RH205's avatar
RH205
Icon for Helper I rankHelper I
11 months 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
    11 months 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,

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.

RH205's avatar
RH205
Icon for Helper I rankHelper I
11 months ago

Perfect, thnx!