I know that direct query mode has limitations in modeling colums and data in general, but maybe you can help me to overcome this limitations in a particular case.
This is the data type format i have
and i would like to work on a report analyzing the data aggregated by years and months, but i can't duplicate, split, transform the data column in any way because of the direct query mode. So the result is like this, data not aggregated at all.
Do you have any suggestion about how i can manage this problem?
You can try to add calculated columns even in DirectQuery mode. On the right side in the Fields panel right-click on the table name and choose New column. Then you can simply use DAX (with several limitations) to create all columns needed, e.g.:
Year = YEAR(YourTable[Posting Date])
Month Number = MONTH(YourTable[Posting Date])