Forum Discussion
sorting by month (text)
ssas tabular model - I have a month column, which is a text datatype, and is based on a day column which is date datatype I have a power bi report doing live connection to this model, when I try ...
Anonymous Your calculation should be:
=YEAR([xxx Day]) * 100 + MONTH([xxx Day])
Set this as your Sort By column of your text month name.
Anonymous Your calculation should be:
=YEAR([xxx Day]) * 100 + MONTH([xxx Day])
Set this as your Sort By column of your text month name.
Greg_Deckler Why multiply * 100
Anonymous See previous reply.
Greg_Deckler so I added a new column with above calculation in the msbi tabular model
year(day_column) * 100 + month
and data format General, data type whole number, the power pivot shows correct values but power bi sums it up and shows wrong values