How to do program to date calculation, in Power BI Live query connection?
Live or Direct. In direct connection, I created Date table in the database and Mark that as a date table in power BI
Refer
https://community.powerbi.com/t5/Community-Blog/Decoding-Direct-Query-in-Power-BI-Part-1-Time-Intell...
Appreciate your Kudos.
Take a look at the September 2023 Power BI update to learn more.
Join Microsoft Reactor and learn from developers.
