Forum Discussion
Modelling: Best Practices with Multiple Date Columns & Values
Good morning all & happy Monday! 😎 This is more of a discussion piece rather than a request for help. I am trying to get to a best practices situation with my model development and wanted to get th...
Thanks
tex628 , I couldn't agree more about the informational value of the blanks/nulls. The majority is coming from Dynamics CRM but I have not seen that date but will keep an eye out going forward.
Cheers,
David
Another advice is to set up the calendar table in Power BI Dataflows. You can take the same power query code that you usually use and create it there. This simply means that you can use the same calendar for every report in the organization and you furthermore add flags for workdays, YTD/MTD etc.. etc..
/ J