Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
Solved! Go to Solution.
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.
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.
bump
User | Count |
---|---|
139 | |
113 | |
103 | |
73 | |
63 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |