cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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
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
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!

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
November Update

Check it Out!

Click here to read more about the November 2020 Updates!

Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

secondImage

Power Platform October Community Highlights

Check out the top community contributors across all of the communities

secondImage

Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors
Top Kudoed Authors