Forum Discussion
Helper VMemory issue, Dax Formula is not being processed
Before you move on, you could just try loading less rows or columns and see if that actually fixes the problem.
Regarding unpivot:
Let's say you have the following 7 columns
date, stock, buy, sell, high, low, vol
you can load the table into power query (get data). Then select the first 2 columns, right click and select "unpivot other columns. This will then give you 4 columns as follows
date, stock, attribute, value.
the last 4 column headings will now be text in the attribute column
the values from the last 4 columns will be values in the values column.
Best set thing to do is build a simple test and see how it works.
You ou then need to change your measures.
Instead of
=sum(table[vol)]
you would write
=calculate(sum(table[value]),table[attribute]="vol")
Community ChampionBefore you move on, you could just try loading less rows or columns and see if that actually fixes the problem.
Regarding unpivot:
Let's say you have the following 7 columns
date, stock, buy, sell, high, low, vol
you can load the table into power query (get data). Then select the first 2 columns, right click and select "unpivot other columns. This will then give you 4 columns as follows
date, stock, attribute, value.
the last 4 column headings will now be text in the attribute column
the values from the last 4 columns will be values in the values column.
Best set thing to do is build a simple test and see how it works.
You ou then need to change your measures.
Instead of
=sum(table[vol)]
you would write
=calculate(sum(table[value]),table[attribute]="vol")
Helper VMattAllington Matt, decreasing the number of rows worked perfectly!
I basically created 2 copies of the same table, one with the values that I want this formula to apply on, and other duplicate table with filtered values don't require the formula (the higher volume of rows are here)
appreciated mate