Forum Discussion

carlosflores's avatar
carlosflores
Helper I
7 years ago

Help with measure

Hello Community, I'm having troubles calculating a measure. This is my table. It can be filtered by Client (on the left) or month (on top):

 

I have a measure that calculates the column "Ttrabajadores activos" but the data is only available for the 17th of september, that's 956, it can be updated by client but not by date. So I'm trying to find a way to work my way backwards and forwards from that 17th of september when I know I have 956 active workers. It should look like this:

 

 

Also, this are my relationships:

 

 

I'd be happy to send the data set, I'm struggling with this for so long... any help is appreciated.

 

Thanks in advance

 

Need Help

2 Replies

  • v-yuta-msft's avatar
    v-yuta-msft
    Community Support
    7 years ago

    Hi carlosflores,

     

    "but the data is only available for the 17th of september, that's 956, it can be updated by client but not by date. So I'm trying to find a way to work my way backwards and forwards from that 17th of september when I know I have 956 active workers."

     

     

    <--- Could you please clarify more details about your requirement and expected result?

     

    Regards,

    Jimmy Tao

    • carlosflores's avatar
      carlosflores
      Helper I
      7 years ago

      Hello v-yuta-msft,

       

      Thanks for your response. The expected result is this:

       

       

      The actives 2 column is what I'm trying to get in Power BI. I'd be happy to share my file as a private message

       

      Thanks in advance