cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Post Patron
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
Community Support

@Bakhtawar 

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.
 

View solution in original post

2 REPLIES 2
Highlighted
Super User IV
Super User IV

@Bakhtawar 

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])



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

Highlighted
Community Support
Community Support

@Bakhtawar 

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.
 

View solution in original post

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors