Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I would like to place these two dates ( yellow) in the matrix table and also calcualte the date difference. and also put SKU, SALES MEETING, AND SUPPLIER NAME(pink) from the master table in the matric table in the visual as well. Once I put the date in, it shows no relationship between these two dates and it turns into can't display this visual Please help. very apprecaited and thanks so much !!
You have to delete the relationship on table with report date and calander and create relationship with the master table based on related ID fileds to use the datediff fucntion.
Hope it resolves your issue? Did I answer your question? Mark my post as a solution! Appreciate your Kudos, Press the thumbs up button!! Linkedin Profile |
Hi thank you for helping, did you meant I have to delate the relationship for calander and connect signle ID from a dimension table? but still doesnt work, I still cant put these two dates into one table. please see my screeshot
User | Count |
---|---|
128 | |
109 | |
100 | |
65 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |