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.
Hey guys, I've got this issue on Power BI. Suppose I sell some products in July, but I will get my money only after 3 months. I want to create a Cash-In column where the values will be shifted 3 cells down. How can I do it in Power BI? Thank you
Solved! Go to Solution.
@Anonymous,
You may refer to the DAX below.
Column = VAR m = Table1[Month] RETURN SUMX ( FILTER ( Table1, Table1[Month] = m - 3 ), Table1[Quantity] * Table1[Price] ) + 0
@Anonymous,
You may refer to the DAX below.
Column = VAR m = Table1[Month] RETURN SUMX ( FILTER ( Table1, Table1[Month] = m - 3 ), Table1[Quantity] * Table1[Price] ) + 0
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 |
---|---|
109 | |
98 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
110 | |
91 | |
84 | |
66 |