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.
Good afternoon, Could anyone help me understand the behavior of this new offset function considering the filters applied to the measurements used?
The "SALDO INICIAL 2" column should bring the previous value of the "SALDO ACUM" column, but only a few lines are returning.
thanks a lot for the help
Thanks Brian, but it didn't work. It's not that context. From what I'm seeing, what's influencing the behavior is the SALDO ACUM measure, because if I insert removefilters the problem is solved. But then I can't apply external filters (month for example)
Provide sample data, Ill take a stab at it. I have worked with it before and have had success.
Hi Brian, take a look if it´s good. Tks a lot
https://drive.google.com/file/d/1aYwt1L15pBTGRAKS_8fXxZzGuzhCjPDX/view?usp=share_link
Your problem is not in the Offset. If you are able to dimensionalize the transaction table where LINHA is a dimension along with the Nrubrica and Descricao da conta is as well. I don't know the data enough, but know that in the offset you are using an all selected becuase of duplicate records, but in the ACUM you have specific filter criteria.
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 |
---|---|
43 | |
26 | |
20 | |
14 | |
8 |
User | Count |
---|---|
73 | |
47 | |
45 | |
17 | |
17 |