Forum Discussion

mas's avatar
mas
Icon for Helper I rankHelper 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
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
Icon for Helper I rankHelper 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
      Icon for Helper I rankHelper 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 .