Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Date intellisense Problem.

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.

 

Need Help

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    5 years ago

    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

  • v-luwang-msft's avatar
    v-luwang-msft
    Community Support
    5 years ago

    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