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 Experts
Looking at the attached screen output how would you do the following calculation in DAX.
i want to be able to work out H5 = H4*G5 and populate that down in a column in my table.
Solved! Go to Solution.
Hi @Anonymous ,
One sample for your reference, please check the following steps as below.
1. Insert an index column in power query.
2. Create a calculated column as below.
H = PRODUCTX(FILTER('Table','Table'[Index] <=EARLIER('Table'[Index])),[1-d/n])
Hi @Anonymous ,
One sample for your reference, please check the following steps as below.
1. Insert an index column in power query.
2. Create a calculated column as below.
H = PRODUCTX(FILTER('Table','Table'[Index] <=EARLIER('Table'[Index])),[1-d/n])
Here is no answer to this question. DAX formulas always depend on the table structure. You need to learn to layout a visual so that you get visual cues similar to what you are used to in Excel. Have a look at my article -it should help you with the concept (not the answer - you will need to work through the problem)
thanks matt for the heads up, this is tricky as hell. 2 hours down and no solution.
Hi Matt
if my row where not filter as per pivot table using teh following dax. Should i get a constant answer as opposed to increment of 1 to last row in table i.e. 1, 2 , 3, 4, etc until 2788. i am see 2788 for each row.
FilteredRows = VAR LatestYear = MAX ( Rates[Year] ) VAR UnfilteredTable = ALL ( Rates ) RETURN COUNTROWS ( FILTER ( UnfilteredTable, Rates[Year] <= LatestYear ) )
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 |
---|---|
113 | |
99 | |
82 | |
70 | |
60 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |