Date intellisense Problem.

[Anonymous]

I am having troble with the Volume in the same period last year, Volume the previous month, month by month dynamics and Volume in previous year.

The values are not shown in the correct month by instid they start from the year.

For example, Volume in the same period last year starts from 2016 year, but it should start fro 1 month 2016: this is the problem for all.

Second, Volume in the previos year does not show it correctly.

Anyone has ideas as to how this can be fixed!

This as the DAX function I have used.

Volume in the previous Month =

CALCULATE(

    [Volume of containers],

    PREVIOUSMONTH('Calendar'[Date])

)

Volume in the previous Month =

CALCULATE(

    [Volume of containers],

    PREVIOUSMONTH('Calendar'[Date])

)

Volume in the previous Month =

CALCULATE(

    [Volume of containers],

    PREVIOUSMONTH('Calendar'[Date])

)

And so on...

Thank you.

[v-luwang-msft]

Hi @Anonymous ,

Has your problem been solved, if so, please consider Accept a correct reply as the solution to help others find it.If not ,could you pls share your pbix file? Remember to remove confident data.

Best Regards

Lucien

[amitchandak]

@Anonymous , Make sure date table is marked as date table, Try like these examples

MTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD('Date'[Date]))
last MTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD(dateadd('Date'[Date],-1,MONTH)))
last month Sales = CALCULATE(SUM(Sales[Sales Amount]),previousmonth('Date'[Date]))

last year MTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD(dateadd('Date'[Date],-12,MONTH)))
Previous year Month Sales = CALCULATE(SUM(Sales[Sales Amount]),previousmonth(dateadd('Date'[Date],-11,MONTH)))
last year MTD (complete) Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD(ENDOFMONTH(dateadd('Date'[Date],-12,MONTH))))
Month behind Sales = CALCULATE(SUM(Sales[Sales Amount]),dateadd('Date'[Date],-1,Month))
Year behind Sales = CALCULATE(SUM(Sales[Sales Amount]),dateadd('Date'[Date],-1,Year))

Why Time Intelligence Fails - Power bi 5 Savior Steps for TI: https://youtu.be/OBf0rjpp5Hw

Power BI — Month on Month with or Without Time Intelligence
https://medium.com/@amitchandak.1978/power-bi-mtd-questions-time-intelligence-3-5-64b0b4a4090e
https://www.youtube.com/watch?v=6LUBbvcxtKA