Date related

Anything related to PowerPivot and DAX Formuale
tommapolve
Posts: 1
Joined: Thu Oct 31, 2019 5:58 am

Date related

Postby tommapolve » Thu Oct 31, 2019 6:08 am

Hi i have this problem
data
Date Prod Data A Data Dep Person Room Reserv
01/01/2019 28/12/2018 07/01/2019 A 200 100
05/01/2019 28/12/2018 07/01/2019 A 200 100
06/01/2019 28/12/2018 07/01/2019 A 200 100
07/01/2019 28/12/2018 07/01/2019 A 200 100
05/01/2019 05/01/2019 07/01/2019 k 201 500
06/01/2019 05/01/2019 07/01/2019 k 201 500
07/01/2019 05/01/2019 07/01/2019 k 201 500
01/03/2019 25/02/2019 03/03/2019 i 80 123
02/03/2019 25/02/2019 03/03/2019 i 80 123
03/03/2019 25/02/2019 03/03/2019 i 80 123
01/02/2019 25/01/2019 02/02/2019 r 147 89
02/02/2019 25/01/2019 02/02/2019 r 147 89

in need to have this result

month (DateProd) month (Data A) Count Room
Gen Gen 5
Feb Feb 3
Mar Mar 0

so in need to have a relation beetween "Month(Date Prod)" and all the occurency of the same month in DataA
thanks a lot
Bye

Return to “PowerPivot/DAX”

Who is online

Users browsing this forum: No registered users and 0 guests

cron