Forum Discussion

manideep547's avatar
manideep547
Helper III
6 years ago

Conversions

Hi all, I have a table  with Id, Destination, date columns  I created three tables destination1 ,destination2 ,Ids Destination1= SUMMARIZE(FILTER('Table,'Table'[DESTINATION]<>blank()),'Table'[DEST...
Need Help
amitchandak's avatar
amitchandak
Super User
6 years ago

You can try creating a table like

Table 2 = 
var _tab2 =SELECTCOLUMNS('Table',"Des",'Table'[Destination],"ID2",'Table'[ID],"Date2",'Table'[Date])
return
FILTER(CROSSJOIN('Table',_tab2),[ID2]='Table'[ID] && [Des]<>'Table'[Destination])

 

this will give you two Destination column. You can change the matching logic as per need. As of now am doing match id=id and Destination<> Destination

 

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution.
In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blogs -Decoding Direct Query - Time Intelligence, Winner Coloring on MAP, HR Analytics, Power BI Working with Non-Standard TimeAnd Comparing Data Across Date Ranges
Proud to be a Datanaut Connect on Linkedin

manideep547's avatar
manideep547
Helper III
6 years ago

amitchandak  any another way to solve that conversions it shows that memory issues because I am dealing with a large amount of data and .pdtx file is nearly 1GB
Memory error: Memory Allocation failure. Try simplifying or reducing the number of queries