Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Ola
Como não quebrar a consulta nativa alterando deste formado de data "yyyymmdd" para este dd/mm/yyyy?
Hi @Vilmar ,
One option is to not do the conversion in this table at all.
You can add a date key column to your calendar table then relate using that instead:
dateKey = Date.ToText([date], "yyyMMdd")
// or
dateKey = Number.From(Date.ToText([date], "yyyMMdd"))
Pete
Proud to be a Datanaut!