search

sql-bi / DaxDateTemplate

Power BI template to create a Date table in DAX
MIT License
265 stars 76 forks source link

[FW StartOfYear] [FW EndOfYear] lines 701-702 #30

Closed P-Blackburn closed 4 years ago

P-Blackburn commented 4 years ago

I am perhaps missing something but I have downloaded the PBIT and the PBX and when I look in the Date Configuration around lines 701-702 I'm seeing that [FW StartOfYear] cannot be found etc...

image

Is there something I should be setting somewhere to overcome this?

marcosqlbi commented 4 years ago

The error you see in the editor is a bug in IntelliSense in Power BI. That line is a valid DAX code that generates a valid table. IntelliSense in Power BI has several other small bugs. If the code is accepted by the editor and doesn't show any error at the bottom of the editor with a yellow background, it's valid DAX code. If you see the error message, that error is accurate and stops the execution of the DAX code. You can go ahead... and perhaps ask Microsoft to fix the bug! :)