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.
Dear All,
I have a sample data model with 3 tables, Date dimension, and two other transaction tables.
I am not able to see data from date dimension as below , if i select joined columns from both tables.
I have attached the sample pbix file.
https://drive.google.com/file/d/1orRByhaVHd7kQxqHgwHfhBgC5RNCtl4g/view?usp=sharing
Solved! Go to Solution.
@sonuojha1 . close time has a timestamp. I create a date from this and then joined on that. Please find the file after signature
Hi @sonuojha1 ,
The purpose of creating this calculated column is to remove the timestamp.
You can also directly delete the timestamp of [CLOSE_TIME] in ‘Edit Query’.
Best regards,
Lionel Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@sonuojha1 . close time has a timestamp. I create a date from this and then joined on that. Please find the file after signature
Why do we need new calculated column as
date(year([CLOSE_TIME]),month([CLOSE_TIME]),DAY([CLOSE_TIME])), however we have date column already in table?
What if we have multiple date columns, then it shouldn't be a good practice to recreate the date columns on top of existing date columns.
Best Regards,
Sonu
Thanks for reply,
Yes, it has timestamp in data, however I converted the data type from date time to Date. So as I understood, we have to remove timestamp from power query itself instead changing type in "Data" tab. Correct?
I appreciate your help.
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 |
---|---|
102 | |
101 | |
87 | |
73 | |
67 |
User | Count |
---|---|
116 | |
109 | |
94 | |
79 | |
72 |