Forum Discussion
Need help with optimization of calculated column
In my model I have a calculated column used to find the creation date of an entry number on the table 'G/L Entry'. The date is located on the table 'G/L Register'. My formula is a follows: Crea...
By the way, if you create the relationship, then you can use this (the fastest option with DAX):
[Creation Date] = RELATED( 'G/L Register[Creation Date] )
Best
Darek
Sounds great. However right now I am struggling with the creation of a key to map the entry no with the number on G/L Register that represents the relevant range.
You should do it in PowerQuery and I assume this is what you do. Certainly, there are myriads of articles on the net about how to do this as it must be a very common thing to do in PQ. Just a matter of a good search...
Best
DarekNo luck so far... :-)
But thanks for your inputs.
If in trouble, please find the relevant forum on PowerQuery and post your question. You can also try people like Chris Webb, Marco Russo, Matt Arlington...
Best
Darek