Forum Discussion

POSPOS's avatar
POSPOS
Icon for Post Partisan rankPost Partisan
2 years ago
Solved

Show last 8 Quarters using DAX

Hi All, I have a requirement to show only the last 8 quarters in the report. If there is no data in a particular quarer then show as zero. Attached below is a sample chart and pbix here.   ...
Need Help
  • Daniel29195's avatar
    Daniel29195
    2 years ago

    POSPOS 

     

    output : 

     

     

    measure : 

    Measure =
    var m = CALCULATE(MAX('154'[Date]), ALL('154'))

    var datasource =
    CALCULATETABLE(
        all('154'[Date]),
        '154'[Date] >= EDATE(m,-8 * 3 ),
        ALL('154')
    )

    RETURN
     IF( MIN('154'[Date])>=EDATE(m,-8 * 3 ) , COUNT('154'[Seq No]),blank())

       
     
    If my response has successfully addressed your issue kindly consider marking it as the accepted solution! This will help others find it quickly. I would appreciate hitting that kudos button 👍🤠
POSPOS's avatar
POSPOS
Icon for Post Partisan rankPost Partisan
2 years ago

Thanks Daniel29195  - Our requirement is to apply activation complete filter to exclude all the blanks dates.

Daniel29195's avatar
Daniel29195
Icon for Community Champion rankCommunity Champion
2 years ago

POSPOS 
simply add the filter slicer, 
but then ,

the first quarter in the chart will disappear since in this quarter the activation complete is blank () 

so it will show only 7 quarters.