topic Re: Average of month year in Power pivot in DAX Commands and Tips

Average of month year in Power pivot

ngoctinh87 — Thu, 10 Aug 2023 04:29:12 GMT

Thanks for everyone's help as requested, many thanks

rsureshkumar98 — Thu, 10 Aug 2023 11:53:41 GMT

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])

rsureshkumar98 — Thu, 10 Aug 2023 11:54:57 GMT