Forum Discussion
Angela_Rom
Helper I
Helper IHow to create query using data from existing tables in Power Query Editor
Hello Everyone, I am trying to create a 12 month view for five groups of data located in five different tables. The issue I am having is that I need the 12 month view to be created in order to ti...
Angela_RomHelper I
Helper IHi Ashish,
Thank you for your response. I tried the calendar table as suggested but this view is limited to the dates provided in the formula. I need the dates to show a 12 month view at all times and be able to change each month as the months change. I think I have to create this in Power Editor query by establishing a date table in the query and merging the data with the date table. Do you know anyway to create a date table as a query?
Ashish_Mathur
Super User
Super UserHi,
This only creates the Calendar Table. What you wan should be written as a DAX expression. Share more information to get more specific help.