Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
any example of these point and brifly explanation please
Solved! Go to Solution.
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.
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.
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])
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
98 | |
86 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |