Forum Discussion

Chthonian's avatar
Chthonian
Helper III
6 years ago

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...
General Comment
tex628's avatar
tex628
Community Champion
6 years ago

Blanks and nulls provide just as much information about a record as any full date. In some of my installations running on Dynamics Navision data I've seen blank values being converted to 1753-01-01, if you ever come across this my advice is to convert to proper null values. 

Br,
J

Chthonian's avatar
Chthonian
Helper III
6 years ago

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

  • tex628's avatar
    tex628
    Community Champion
    6 years ago

    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