Calculate() with specific Date filter

Anything related to PowerPivot and DAX Formuale
LeviGer
Posts: 1
Joined: Wed May 08, 2019 4:38 am

Calculate() with specific Date filter

Postby LeviGer » Wed May 08, 2019 4:45 am


Bernard Heymans
Posts: 34
Joined: Wed Feb 28, 2018 12:18 am

Re: Calculate() with specific Date filter

Postby Bernard Heymans » Fri May 17, 2019 5:43 pm

Hi Levinger,

Just had a look,

for me this work:

as Decembre 1st 2018 = 43435

NS.01dec2018 :=CALCULATE(NS , ddate[dday]=43435)
but it show the same value for any month
NS.01dec2018 := CALCULATE( NS , filter( ddate , ddate[dday] = 43435 )

regards,

Bernard.

Bernard Heymans
Posts: 34
Joined: Wed Feb 28, 2018 12:18 am

Re: Calculate() with specific Date filter

Postby Bernard Heymans » Fri May 17, 2019 5:58 pm

Could this help?

Max_Date =if( [NS.] >0 , MAX('Data no customer'[Date - Calendar Year/Month]))

Attention: my accounting year is starting April.. month 1 =April

Image

Regards,

Bernard


Return to “PowerPivot/DAX”

Who is online

Users browsing this forum: MSN [Bot] and 2 guests

cron