Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
i have two tables
both table have date column.*table1 and table2
i create a clendar table. and join the both tables date column into calendar table date column .. but i did not get the result
like
when i create drag calendar date and table 1 date column into table then i only get table1 dates. other one looks emty.
first i joined both tables from ID and then date into calendar table
@rebam12 , First mark date table as DATE TABLE by going to modelling tab and select Mark as Date Table
Ensure that the relationships are set to "Many to One" and "Single" direction from the calendar table currently it is bi-directional
If you need to use both tables in the same visual, you might need to set one of the relationships to "Inactive" and use DAX functions like USERELATIONSHIP to activate it when necessary.
And Use calender table column in visuals
Proud to be a Super User! |
|
table 1 has date column which data type is also date .. and same for other tables .
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
110 | |
104 | |
103 | |
87 | |
61 |
User | Count |
---|---|
168 | |
138 | |
134 | |
102 | |
86 |