Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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
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
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
User | Count |
---|---|
114 | |
107 | |
103 | |
57 | |
36 |
User | Count |
---|---|
149 | |
136 | |
101 | |
91 | |
62 |