column number

2 Topics

Decimal change to Whole number not working in Matrix
Hello helpers, I have dataset orginally build as Decimal (10,2) format numbers, after i loaded to Power BI, i changed the number to Whole Number, Now the dataset shows as whole number fine, but the numbers in visuals still show 2 decimal 0s. And when i select the column, it shows as Whole number Formatting: Dataset: Display in Matrix Any suggestions please? Thank you
Anonymous
3 years ago Place Custom Visuals Development Discussion
1.1KViews
0likes
2Comments
Reference Column Number with Measures
I have a table with 10 columns. The first 5 have fixed column names. The last 5 have column names that I would like renamable by a layman according to needs. These last 5 columns are also ones that I need to write measures for with DAX. Is it possible to reference the columns by their number instead of their name? For example, first column might be Table[0], second column might be Table[1] ... etc. I am thinking if referencing by number is possible, I can store this in a variable and then reference the column dynamically when writing my measures. Or if there is a better way, please let me know, I only have very basic DAX knowledge.
Solved
Nie
5 years ago Place DAX Commands and Tips
2.1KViews
0likes
2Comments