Forum Discussion

ankurdsharma's avatar
ankurdsharma
Frequent Visitor
7 years ago
Solved

DAX Help

Hi,   I am  new to Power BI and want to achieve  something which I have already done using sql. Following is the scenario:-   (1) I am having a table with Customer details and having columns like...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    7 years ago

    Hi,

     

    You may refer to my solution in this PBI file.

     

    Hope this helps.

     

Ashish_Mathur's avatar
Ashish_Mathur
Super User
7 years ago

Hi,

 

If you can show me the result you are expecting, i will be able to help you much better.

ankurdsharma's avatar
ankurdsharma
Frequent Visitor
7 years ago

Hi Ashish, 

 

Let me explaing it to you again. The sample which you have sent and is generating CustomerID which are churned as per attached screen. What I want is to store the results specially 'CustomerID' (these can be more than one) in separate table dynamically to use them again for another calculation. Let me know if make you to understand this.

I am talking about right side table

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    7 years ago

    Hi,

     

    I do not know how to do that.