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.
Expanded explanation--
In this data I want to do something like:
if team on row a = team on row b
and end of week on row a = end of week on row b - 7
then put the net change amount from row a into a field named 'running total' on row b
I am trying to write the following:
If the field PriorWeek in this row equals the EndDate in another row, put in the NetAmount from the other row as PriorAmount.
ie: if the Net Amount for 5/1/20 is 50, put that as PriorAmount in the row for 5/8/20
There is not enough information to be able to answer you question well.
Can you post some example data following the suggestions outlined in the following link:
How to Get Your Question Answered Quickly - Microsoft Power BI Community
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 |
---|---|
15 | |
5 | |
4 | |
2 | |
2 |
User | Count |
---|---|
15 | |
7 | |
5 | |
3 | |
3 |