I need help with creating another table from the existing table with measures calculated with few conditions.
I have a dataset with 10 Years for 2 companies and calculated measure (Value_cal)
Attached the sample data
Now I want to create another table from an existing table with below filters
Company =" Company1" and month, year of the data set=2019- Jan and summarize calculated measure with respect to each product
Any help would be great full
Please see the attached Table Expression.
YourNewTable = ADDCOLUMNS( GROUPBY( FILTER( ADDCOLUMNS( YourTable, "YearMonth", VAR d = YourTable[Date] RETURN YEAR( d ) * 100 + MONTH( d ) ), YourTable[Company] = "Company1" && [YearMonth] = 201901 ), YourTable[Company], YourTable[Product], [YearMonth] ), "Value_cal", CALCULATE( SUM( YourTable[Value_cal] ) ) -- or replace Calculate with your Measure )
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks for the reply,
In my original dataset,
To calculate the final Value, I have Fixed the values with respect to year and each category and also used all except functions.
As per the above solution, it was giving wrong values
Any solution would be grateful