Forum Discussion
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. 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
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])
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.
