1. Load your data:
Import your dataset into Power BI.
2. Open Power Query Editor:
Go to the "Home" tab and click on "Transform Data" to open the Power Query Editor.
3. Add Custom Columns:
In the Power Query Editor, select the column that contains your date values.
Extract Day Of Month:
Go to the "Add Column" tab.
Click on "Date" and then select "Day" -> "Day".
This will create a new column with the "Day Of Month" extracted from your date column.
Extract Day Of Week:
With the date column still selected, go to the "Add Column" tab.
Click on "Date" and then select "Day" -> "Day Of Week".
This will create a new column with the "Day Of Week" extracted from your date column.
Tip
The "Day Of Week" will be shown as - 0,1,2,3,4,5,6,7. To know exactly which number belongs to which day, do following steps
With the date column still selected, go to the "Add Column" tab.
Click on "Date" and then select "Day" -> "Name Of The Day".
This will create a new column with the "Name Of Day" extracted from your date column.
Extract Day Of Year:
Again, with the date column selected, go to the "Add Column" tab.
Click on "Date" and then select "Day" -> "Day Of Year".
This will create a new column with the "Day Of Year" extracted from your date column.
4. Close and Apply:
Once you have added all the necessary columns, click on "Close & Apply" to apply the changes and return to the main Power BI window.
You should now have separate columns for Day of Month, Day Of Week and Day of year in your dataset.
1. Load your data:
Import your dataset into Power BI.
2. Open Power Query Editor:
Go to the "Home" tab and click on "Transform Data" to open the Power Query Editor.
3. Add Custom Columns:
In the Power Query Editor, select the column that contains your date values.
Extract Week Of Month:
Go to the "Add Column" tab.
Click on "Date" and then select "Week" -> "Week Of Month".
This will create a new column with the "Week Of Month" extracted from your date column.
Extract Week Of Year:
With the date column still selected, go to the "Add Column" tab.
Click on "Date" and then select "Week" -> "Week Of Year".
This will create a new column with the "Week Of Year" extracted from your date column.
4. Close and Apply:
Once you have added all the necessary columns, click on "Close & Apply" to apply the changes and return to the main Power BI window.
You should now have separate columns for Week of Month and Week of year in your dataset.