Forum Discussion
Power Query M Code to look up value at the intersection of specific record & field
I come from an Excel user background & are trying to build my skills in Power BI & specifically Power Query M Code. My business have asked me to write a simple Power BI model to report graphically on...
Personal opinion/word of advice: Don't do it (in Power BI). Use an external dates/calendar table that you maintain in an Excel file on a sharepoint, or in a SQL Server table. That will not just save you lots of works, but also (hopefully) give you back some sanity. Especially with your off-standard fiscal calendar.
Personal opinion/word of advice: Don't do it (in Power BI). Use an external dates/calendar table that you maintain in an Excel file on a sharepoint, or in a SQL Server table. That will not just save you lots of works, but also (hopefully) give you back some sanity. Especially with your off-standard fiscal calendar.