Forum Discussion
Conversions
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
amitchandak
could you suggest me how to find the frequency of the customer, like If the customer has the transactions once or more every 2 months? (count of the customer)Try
Measure = CALCULATE(DISTINCTCOUNT('Table'[ID]),ALLEXCEPT('Table','Table'[Month-Year])) New amount = CALCULATE(SUM('Table'[Amout]),VALUES('Table'[ID]),FILTER('Table',[Measure]>1))If it do not resolve. Please create a new Message.
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 queriesamitchandak
I getting this error while creating the table
Memory error: Memory Allocation failure. Try simplifying or reducing the number of queries
is there any alternative way to slove that
