Time Intelligence Question

[brs09j]

I have two tables with data I would like to create a visual with

Table A

-Year column (text  Ex. 2016)

-Month column (text Ex. 01)

-Month + Year column (date/time Ex. August 2016)

Table B

-No dates at all

I was going to build a date table with Calendar but realized I can't join it to the tables because they don't have the right data. What should I do here? I tried creating a conditional column on table A that always made the value = 01. From there, I merged the year, month and day column. With the new column I joined it to the date table. However, I think there has to be a better way. Plus, I need the date table to have a relationship with Table B as well.

[v-chuncz-msft · Accepted solution]

@brs09j,

Your requirement is not very clear, please post some sample data. By the way, for any time intelligence function, you could implement a custom DAX formula.

[brs09j]

bump