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 
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)

  • amitchandak's avatar
    amitchandak
    Super User
    6 years ago

    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.