Forum Discussion

Beast's avatar
Beast
Frequent Visitor
3 years ago

Filter by Overall and Current Month

Hi

Is it possible to get the below requirement in Dax Query. I have a Date Table, which will be used to Filter the Visuals.

I Need to classify the dates as "OverAll" and Current Month" (Note: Not Previous Month and Current Month)

1. Overall -> Should display all Dates including current month

2. Current Month -> Should display only current Month.

 

I can able to get the final result by creating two different columns (Overall and Current Month) but I need to have both in same column, may be in dynamic way.

Need Help
Tips and Tricks

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    3 years ago

    Beast ,

     

    This Month =
    var _max = eomonth(if(isfiltered('Date'),MAX( 'Date'[Date]) , today()),0)
    var _min = eomonth(_max,-1)+1 ,
    return
    CALCULATE([net] ,DATESBETWEEN('Date'[Date],_min,_max))

     

     

    Complete Date =
    var _max = eomonth(if(isfiltered('Date'),MAX( 'Date'[Date]) , today()),0)
    return
    CALCULATE([net] ,filter(all(Date), Date[Date]< = _max))

    Why Time Intelligence Fails - Powerbi 5 Savior Steps for TI :https://youtu.be/OBf0rjpp5Hw
    https://amitchandak.medium.com/power-bi-5-key-points-to-make-time-intelligence-successful-bd52912a5bd4
    To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :radacad sqlbi My Video Series Appreciate your Kudos.

    • Beast's avatar
      Beast
      Frequent Visitor
      3 years ago

      amitchandak As I said above, I already have two columns separately such as Overall and Current Month.

      My requirement is to have both at same column. Such as 

      Type
      Overall 
      Current Month