CREATE A NEW TABLE OF LAST 3 MONTHS

[LinhDO]

Hi all,

I try this DAX to create a new table of last 3 months but it does not work correctly.

SUMMARIZECOLUMNS(table[channel], table[Cust code], table[Item code],

"Sales",CALCULATE(SUM(table[Sales]),DATESINPERIOD(table[date],LASTDATE(table[date]),-3,MONTH)))

Please help!!!!!!!!!!!

[Anonymous]

Hi

Can you provide more information as to what is incorrect on the result since the DAX seems correct?

Tomas Santandreu Polanco |Principal Business Intelligence Consultant
www.designmind.com

[LinhDO]

I have found the solution. Thx 🙂