Dont move to measure or dim.
We can use the str([date]) or str([id])
This will help you. if not then attach workbook
Thanks for you answer.
This is exactly what I have been doing. But there is the limitation for the number of columns, and I'd like to use the features of measure values, such as the color, shapes etc.
Number of columns you can increase upto 16..Go to -->Analysis--->Table Layout-->Advanced--->Under the column section you can increase the number of columns.
Hi if you want to use measure in colour then drag measure names in colours.
Please attache workbook and add image what is your correct requirement.
Sorry, I may not be very clear about this question. What I need is to create a column that is constituted by two sources (One is the number; and another is the date). I'd like to use this filed as a measure value, as I would like to put colors on values (Green for the date, and Red for the number). Another reason I need to do that is I have 16+ columns like this. So I could not put it as dim column.
Attached sreenshot for reference.
use this calc
if attr([Id]) = 2 then SUM(source2.[Spend]) else sum(source1) end
Please attach sample workbook.