Forum Discussion
Most popular from Dataverse
Hi there,
I have a desk booking app, and the desks which have been booked are in a Dataverse table column.
I want to show a simple data card which counts the amount of times each individual desk reference appears in this column, and only shows the top result (the one with the most bookings).
Any ideas how I can do this?
Thanks
K.
Hi Kosenurm
Step1: connect to dataverse in Power BI Desktop,
Connect to Dataverse from Power BI Desktop
Step2: After get data from dataverse, create measures like bellow( I create a sample for your reference, see file attached bellow)
count = COUNT('Table'[desk])MaxCount = VAR _count = MAXX ( 'Table', [count] ) VAR _name = CALCULATE ( MAX ( 'Table'[desk] ), FILTER ( 'Table', [count] = _count ) ) RETURN _name & UNICHAR ( 10 ) & _countBest Regards,
Community Support Team _Tang
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
Hi Kosenurm
Step1: connect to dataverse in Power BI Desktop,
Connect to Dataverse from Power BI Desktop
Step2: After get data from dataverse, create measures like bellow( I create a sample for your reference, see file attached bellow)
count = COUNT('Table'[desk])MaxCount = VAR _count = MAXX ( 'Table', [count] ) VAR _name = CALCULATE ( MAX ( 'Table'[desk] ), FILTER ( 'Table', [count] = _count ) ) RETURN _name & UNICHAR ( 10 ) & _countBest Regards,
Community Support Team _Tang
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.
Thanks, but when I do this, I get this error message - any ideas?
Error Message:
OLE DB or ODBC error: [DataSource.Error] Microsoft SQL: Input query length exceeding the supported maximum length.
