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.
Hi in Below Table I would Like to calculate the row YTD and next Initial FC in one column, Please see my example below, Please let me know if anyone can provide me the DAX query for same.
Solved! Go to Solution.
Hi @Anonymous,
1. Add an index in the Query Editor.
2. Add a calculated column with the following formula.
Column = VAR initial = CALCULATE ( SUM ( [YTD] ), FILTER ( 'Table1', 'Table1'[Index] = 1 ) ) VAR currentIndex = [Index] RETURN IF ( [Index] = 1, 0, initial + CALCULATE ( SUM ( Table1[Initial FC] ), FILTER ( 'Table1', 'Table1'[Index] >= 2 && 'Table1'[Index] <= currentIndex ) ) )
Best Regards,
Dale
Hi @Anonymous,
1. Add an index in the Query Editor.
2. Add a calculated column with the following formula.
Column = VAR initial = CALCULATE ( SUM ( [YTD] ), FILTER ( 'Table1', 'Table1'[Index] = 1 ) ) VAR currentIndex = [Index] RETURN IF ( [Index] = 1, 0, initial + CALCULATE ( SUM ( Table1[Initial FC] ), FILTER ( 'Table1', 'Table1'[Index] >= 2 && 'Table1'[Index] <= currentIndex ) ) )
Best Regards,
Dale
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 |
---|---|
107 | |
94 | |
77 | |
63 | |
50 |
User | Count |
---|---|
147 | |
106 | |
104 | |
87 | |
61 |