Forum Discussion
Solved
Measure to calculate sum by groups
I have one year of monthly data for 14 Locations in a DataSet that has 4 columns: i) Location_ID; ii) FloorArea in squared meters; iii) MonthYear; and iv) Amount. Some sites do not have a full ye...
Hi I would go back to power query and re model your data.
For example, i would create a dimension table which holds 1 single value per location id, you would only need 2 columns (Location ID & Floor Area) once this table is created you can join it to your fact data on location id.
This will allow you to accurately calculate the floor area.
ajohnso2
Solution Supplier
Solution SupplierHi I would go back to power query and re model your data.
For example, i would create a dimension table which holds 1 single value per location id, you would only need 2 columns (Location ID & Floor Area) once this table is created you can join it to your fact data on location id.
This will allow you to accurately calculate the floor area.
Thanks for your fresh look at things. It's working very well now.