Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
97 | |
80 | |
67 | |
63 |
User | Count |
---|---|
147 | |
110 | |
108 | |
85 | |
64 |