Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Calculated Column taking hours to populate

Hi Guys,    I'm having an issue where I created a simple calculated column ->  FirstTrxDate= MINX(     FILTER(         k3c_pointaudittrails,         k3c_pointaudittrails[k3c_transactiondate]...
Need Help
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Could you do it upfront in Power Query? 

Where you do a grouped indexing, based on k3c_pointaudittrails so you get something like this, and then you build your measures based on calculate(something,table[index]=1) ? 

Example Pbix file. 

https://we.tl/t-vtIjY7NEgn