cancel
Showing results for
Did you mean:
Highlighted
Post Patron

## dax points

any example of these point and brifly explanation please

• We can use values of mixed data types as inputs in a DAX formula. Data type conversion will take place automatically during execution of the formula.

• In some cases, DAX functions return a full table which can be used in other DAX formulas that need a complete set of values. However, you cannot display this table’s contents.
1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support

1. You cannot have mixed datatypes for one column. You can input mixed datatypes for different columns, for example if you enter 100, it will automatically display as Numerical type, if you have ABC, it becomes Text type, for 2020.4.24 it automatically show as Date type. These data types needs to be manually converted to others when your right dax formulas, you can do that by changing the datatype on the top menu OR using dax Format() function to convert.

2. Sometime you can create a virtual table to reduce pibx size, which is not displayed.

Typical example is Summarize(), see: http://blog.extrobe.co.uk/blog/2016/11/26/creating-virtual-tables-in-power-bi-using-dax/

You can then use the virtual fields in the virtual table to create dax formulas.

Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

2 REPLIES 2
Highlighted
Super User IV

No, you can not have mixed data type. You need to make sure they are same.

We typically add & "" to make them as text.

There are many which return table can be a new table or a new var hold table in a measure.

Summarize , selectcolumns , union, distinct

New Table = Summarize (Table, Table[A], "B",sum(table[B])

New Measure=

var _tab = Summarize (Table, Table[A], "B",sum(table[B])

return

averagex(_tab,[B])

Proud to be a Super User!

Highlighted
Community Support

1. You cannot have mixed datatypes for one column. You can input mixed datatypes for different columns, for example if you enter 100, it will automatically display as Numerical type, if you have ABC, it becomes Text type, for 2020.4.24 it automatically show as Date type. These data types needs to be manually converted to others when your right dax formulas, you can do that by changing the datatype on the top menu OR using dax Format() function to convert.

2. Sometime you can create a virtual table to reduce pibx size, which is not displayed.

Typical example is Summarize(), see: http://blog.extrobe.co.uk/blog/2016/11/26/creating-virtual-tables-in-power-bi-using-dax/

You can then use the virtual fields in the virtual table to create dax formulas.

Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Announcements

#### Power Platform Community Conference

Check out the on demand sessions that are available now!

#### Microsoft Power Platform Communities

Check out the Winners!

#### Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors