Forum Discussion
DAX Help
So I have a matrix that is being generated by this query: -
MTD Consumed data= TOTALMTD([Current Month Consumed data],'Inventory Date'[Date
What I want is the that I want to create a separate measure for each columns (col1, col2 and so on) that gives me the sum of the the column. For example: A measure that gives me sum of col1 that is 1707.76 and second measure that gives 1749.67
8 Replies
How and where (in what context) are you going to use this total - that will determine how to write the Measure.
For instance - you don't have to change anything in the Measure if you display instead of Date - Month on the Rows.
Sean I intend to use this measure and multiply this with another measure to get the final output. So that's why I want to get the numeric output.
