Forum Discussion

mas's avatar
mas
Helper I
8 years ago

data(list) in dynamics 365

hello, i have a problem, when i connect my power bi desktop to dynamics 365 , i  get numbers . explication: in order to collect list(in dynamycs365) ,but i get numbers . exemple :  i want to get :...
Need Help
mas's avatar
mas
Helper I
8 years ago

i used powerbi optionSet xrmtoolbox ..but how creating relation between table "gap_powerbioptionsetrefs" and my existing table 'opportun..' ?

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi mas,

 

You can choose one column as group/category, then write formula to calculate count of collection number based on group column.
After above operation, add calculate column to mark tag based on collection count.

 

Regards,

Xiaoxin Sheng

  • mas's avatar
    mas
    Helper I
    8 years ago

    hello, i do not understood your solution.

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      HI mas,

       

      I mean add calculated column to table to count rows based on category column which I mentioned.

      For example:

      Sample =
COUNTX ( FILTER ( ALL ( Table ), [ID] = EARLIER ( [ID] ) ), [Collection] )

       

      Regards,

      Xiaoxin Sheng

      • mas's avatar
        mas
        Helper I
        8 years ago

        hi Xiaoxin,

        can you illustrate by exemple to understand. PB still collect identifier, not value of list (list in dynamics 365).

        thank you .