Forum Discussion

icdns's avatar
icdns
Icon for Post Patron rankPost Patron
6 years ago

SHOW LATEST 3 MONTH IN BAR GRAPH

Hi guys,    Could somebody help me in displaying the LATEST 3 MONTHS data that will show in my bar graph. I have my DIM_CALENDAR and Date_Key as my dimension which is connected to my Date column in...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

icdns , This formula seems correct to me

Hope FullDateAlternateKey is date column ?

DIM_CALENDAR is marked as date table ?

DIM_CALENDAR has all the required Dates?

 

LATEST_3_MONTHS = CALCULATE(sum(FCT_TABLE[ PERCENTAGE ]),DATESINPERIOD('DIM_CALENDAR'[FullDateAlternateKey],MAX(FCT_TABLE[DATE]),-3,MONTH))

 

Try to select a month using slicer and check if it works.

 

if it does not work

Can you share a sample pbix after removing sensitive data.

  • icdns's avatar
    icdns
    Icon for Post Patron rankPost Patron
    6 years ago

    Hi, 

     

    To answer your questions: 

     

    Hope FullDateAlternateKey is date column ? yes

    DIM_CALENDAR is marked as date table ? yes

    DIM_CALENDAR has all the required Dates? yes

     

    I just thinked that it only depends on my YEAR filter, not month filter. 

    Whatever my year is. it will only show the latest 3 months of data. 

    Can I still use this formula?