Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 |
---|---|
102 | |
91 | |
87 | |
79 | |
71 |
User | Count |
---|---|
113 | |
105 | |
101 | |
75 | |
64 |