Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi Guys,
I have created a table with dates as per script below now I need to have each of the days listed lets say 5 times for each day with each date having channel A, B, C, D, E. How can I add this as at the minute each date shows only 1's and I didnt add the records yet, not sure how to achieve that.
I will be very greatful for your support 🙂
Solved! Go to Solution.
@pszczulka1984 , See if this can help
crossjoin
new table = crossjoin([Date],[Channel])
https://docs.microsoft.com/en-us/dax/crossjoin-function-dax
@pszczulka1984 , Not very clear , You can have time table
https://kohera.be/blog/power-bi/how-to-create-a-time-table-in-power-bi-in-a-few-simple-steps/
Join date with date and time with time
Time = [date time].time
date =[date time].date
Hello,
1st of all thank you very much for taking time to read my post.
What I am trying to achieve is as per table below. So each date will appear as many times as many channels I have.
Date | Channel |
1/01/2020 | A |
1/01/2020 | B |
1/01/2020 | C |
2/01/2020 | A |
2/01/2020 | B |
2/01/2020 | C |
3/01/2020 | A |
3/01/2020 | B |
3/01/2020 | C |
Thank you in advance,
@pszczulka1984 , See if this can help
crossjoin
new table = crossjoin([Date],[Channel])
https://docs.microsoft.com/en-us/dax/crossjoin-function-dax
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
98 | |
86 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |