Forum Discussion
need to make custom reports.
HI all, Wanted to custom BI like student Name: abc Student Class: 1st where Student Name: is a label and abc from DB how to i add label feild cn any one please help in the same. Thanks ...
HI Amit
I have a student table which consists of
| Roll no | Name | Date of admission | Class |
| 1 | Dan | 12-06-2001 | 9 |
| 2 | Ron | 20-06-2002 | 8 |
| 3 | Dave | 11-05-2003 | 7 |
Expected report (i am basically trying to rewrite my crystal reports to power bi)
on passing the roll no should be getting thesr values. the label feild will have custom texts not the name on the column
| ABC School | ||
| Student Name(these are labels ) | Dan | |
| Class(these are labels ) | 9 |
amitchandak
Super User
Super UserI think it can of the custom display. Assumption Roll no is selected.
union(
summarize(table,"ABC School","","-",""),
summarize(table,"ABC School","Student Name(these are labels )","-",max(Name)),
summarize(table,"ABC School","Class(these are labels )","-",max(Class)&"")
)
summarize can replace with selectcolumns with few changes. You can try that. No need of max in case selectcolumns