Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Up Program - Visualize data with Power BI
Unanswered

Lesson #9 - Mapping to dimData - Needed Derived Column to Remove Time

(2) ShareShare
ReportReport
Posted on by 16
This is not a question but an observation based on what I experienced. I am in US Central time zone and my initial attempts to use the dimDate dimension tied to the Loads was not working. I ended up adding adding a new column called LoanStartDateAsDate that got rid of the time value associated with the loan record. I removed the recommended [Loan Start Date] mapping and remapped to my derived LoanStartDateAsDate column. This fixed the mismatch based on the time. 
Categories:

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Leaderboard >

Featured topics