I have a few different tables I'm hoping to link up, but the layout is slightly different. On one of the tables, there is a column that includes the date of the transactions in YYYYMM format. In the other tables, the date is actually the header of a column (typically in the same format). I'm extremely new to PBI, and I'm wondering if it's going to be possible to get these to all play nice given the different layouts? From playing around I'm having trouble working with the visuals for the tables that have the dates set as column headers.
I'm also having a smaller issue with the YYYYMM format in general, and not sure if whether it's my source data, me, or PBI. I am able to work around the issue using a find and replace since there are only so many months in a year and my data only spans a few years, but I'm wondering if it's possible to get PBI to recognize that format and utilize it?
Thanks in advance for any assistance....
