Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Need multiple relations on duplicated table

Hi all   I have a table with objects. There are columns (activeOn = active since) and (DeadOn = inactive from). I need in a matrix, per month, the number of objects that got active in this month, ...
Need Help
v-danhe-msft's avatar
v-danhe-msft
Microsoft Employee
7 years ago

Hi Anonymous ,

It is hard to reproduce your problem, could you please share your pbix file and post your desired result if possible?

 

Regards,

Daniel He

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hello v-danhe-msft 

 

Yes i can upload it. But it has sensitive data, so before i invest some time to recreate the data, is there any way i can hide the source-data?

 

In Query editing mode i have some tables filtered or removed columns that are sensitive, but when i share the pbix it can easily be looked into. So i mean can i disable changing the steps?

  • v-danhe-msft's avatar
    v-danhe-msft
    Microsoft Employee
    7 years ago

    Hi Anonymous ,

    You could just create a simple sample for me and post your desired result, I will try to figure out it.

     

    Regards,

    Daniel He

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      v-danhe-msft Example file available here: https://www.dropbox.com/s/1fnl666ysic6c2h/example.pbix?dl=0

       

      (What is the best way to upload/show pbix files btw?)

       

      The file:

      You see 2 tables. The top one is my current situation, bottom one the expected numbers for the "ActiveOn" column.

      I tried to keep it as simple as possible so i hope you understand it.