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 severals tables in my modeling view...
all tables are linked based on Date and Brand fields
In all my pages I have two segments component (date and brand) which sort my data in the way I want...
I want to add one more table but I only have the month and the number of the year... I can't have the detail day by day
How it's possible mixing day and month to use my existing date segment ?
Any help would be appreciated.
Thanks,
Han
Solved! Go to Solution.
Hello @noliverte
You can add a column (month-year date) to the table you want to add in that is the date of the first day of the month year so for 09-2015 it would be 1/9/2015. For 10-2015 it would be 1/10/2015. Once you have that you can link it into your regular date table.
month-year | month-year date |
09-2015 | 1/9/2015 |
09-2015 | 1/9/2015 |
10-2015 | 1/10/2015 |
10-2015 | 1/10/2015 |
11-2015 | 1/11/2015 |
You join the table on the [month-year date] column
Hello @noliverte
You can add a column (month-year date) to the table you want to add in that is the date of the first day of the month year so for 09-2015 it would be 1/9/2015. For 10-2015 it would be 1/10/2015. Once you have that you can link it into your regular date table.
month-year | month-year date |
09-2015 | 1/9/2015 |
09-2015 | 1/9/2015 |
10-2015 | 1/10/2015 |
10-2015 | 1/10/2015 |
11-2015 | 1/11/2015 |
You join the table on the [month-year date] column
Hello,
Very easy solution and it works, thank you.
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 |
---|---|
106 | |
98 | |
80 | |
67 | |
63 |
User | Count |
---|---|
145 | |
111 | |
104 | |
84 | |
64 |