Average of month year in Power pivot

[ngoctinh87]

Thanks for everyone's help as requested, many thanks

[rsureshkumar98]

[rsureshkumar98]

Hi ngoctinh87

Using Power Query, you can create 3 column as below 

1. Day from the From Date

=DAY(Table1[FROM DATE])

2. Next month using below

=var a = Table1[FROM DATE]

return

DATE(YEAR(a),MONTH(a)+1,DAY(a))

3. create a if condition as below 

=IF(Table1[Day_From Date]<=15,Table1[FROM DATE],[NextMonth])