Forum Discussion
Solved
Quick Measure YoY%
The formula automatically generated by Quick Measure YoY% is as follows with a ".[Date]" attached to the Date Column. This gives wrong result, while I get correct result if I remove the .[Date] part ...
Thanks a lot for the response. And thanks for introducing to DAX Studio :)
Hi powerrdl, when you create the tabular model in power bi after applying changes, Power Bi creates by default a hidden table for each date column in the dataset.
When you write 'Table'[Date] you are using the field on your table, otherwise if you write 'Table'[Date].[Date] you will be using the column in the hidden table.
In order to have a better understanding you can download DAX Studio and load a power bi file with date column. There you will clarify ideas.
Regards,
P/D So strange it work without .[Date]
Thanks a lot for the response. And thanks for introducing to DAX Studio :)