Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi @Paulyeo11 ,
If i understand you correctly, you could click Transform data to open Query Editor, then find the queries under advance editor.
https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-query-overview#advanced-editor
Best Regards,
Jay
Hi @Paulyeo11 ,
If i understand you correctly, you could click Transform data to open Query Editor, then find the queries under advance editor.
https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-query-overview#advanced-editor
Best Regards,
Jay
@Paulyeo11 , You can copy the Power Query Script table. Not Dax script tables as of now.
You can save a pbix with a date table and use it.
Or best you create a calendar table using Addcolumns like
Date = ADDCOLUMNS(CALENDAR(date(2018,01,01),date(2020,12,31)) ,"Month Year", FORMAT([Date],"mmm-yyyy") ,"Month Year sort", FORMAT([Date],"yyyymm") ,"Year" , year([Date]))
You can easily copy paste table from one place to another
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |