Calendar Function not working with new version of power BI

[Anonymous]

The following measure is not working in powerbi desktop.

3 Months Unit Sold = CALCULATE([Units Sold],DATESINPERIOD(DimDate[FullDateAlternateKey],LASTDATE(DimDate[FullDateAlternateKey]),-3,MONTH))

When the same measure is created in Excel 2016 powerpivot it works.

Is this a bug?

[Ashish_Mathur · Accepted solution]

Hi,

Here are the changes i made

1. I edited your date relationship of dates.  I hehashed it to "DueDate column of the FactInternetSalesTable to FullDateAlternateKey column of the DimDate Table.  See image below
2. I edited your 3 Months Units sold calculated field formula to

=CALCULATE([Units Sold],DATESINPERIOD(DimDate[FullDateAlternateKey],LASTDATE(DimDate[FullDateAlternateKey]),-3,MONTH))

The correct result is shown below