data(list) in dynamics 365

[mas]

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 :

1-new

2-smart

3-best

but power bi collect this:

19920213

19920214

19920212

question: how power bi can collect the data(informations), not numbers.?

[mas]

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

[Anonymous]

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]

hello, i do not understood your solution.

[Anonymous]

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]

hi Xiaoxin,

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

thank you .