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 "Ttra...
Need Help
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