Forum Discussion

akhaliq7's avatar
akhaliq7
Post Prodigy
2 years ago
Solved

Help with Matrix

I would like my matrix to look like the below in Power BI:     Below is my current DAX code: Admin = VAR StartDate = CALCULATE( STARTOFYEAR('DimDate'[Date]), DimDate[Date] = EDATE(TODA...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi akhaliq7 

 

You can add a relative date filter or a relative date slicer to show last 2 months. 

Create a relative date slicer or filter in Power BI - Power BI | Microsoft Learn

 

Or try a measure like

Measure = 
IF (
    MONTH ( MAX ( DimDate[Date] ) ) < MONTH ( TODAY () ),
    COALESCE ( [your measure], 0 ),
    BLANK ()
)

 

BTW, it seems you are computing something like YTD, you may try something simpler for the measure

CALCULATE (
    [measure],
    DATESYTD ( 'Date'[Date] )
)

Basics of Time Intelligence in DAX for Power BI; Year to Date, Quarter to Date, Month to Date - RADACAD

 

Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!

  • akhaliq7's avatar
    akhaliq7
    Post Prodigy
    2 years ago

    Thanks for your help. I used the relative date filter and will try out the measures later.