Forum Discussion

Mitchblue006's avatar
Mitchblue006
Advocate I
3 years ago
Solved

Visualization not working with Date Range Slicer

Hi Everyone

 

I am building a dashboard with visuals that will ...
1) Allow the user to have a rev counter visual that shows previous and current month measure
2) User can manipulate date Slicer for any range on the dashboard

Here...above...the visuals look good...since I use DAX in summary table to link to rev counters with TODAY()...

However, if I change the date slicer range to previous dates (I have rev counters that don't know which date to classify previous and current months)- I read previous forums...and I replaced TODAY() with MAX(Date'Date') and does not work...repeat...does not work

Here above...is the problem with date selector as slicer...this is a bad visual

I will attach some of the DAX from the Summary Table that connects to the Rev Counters visual...

SummaryCancel = SUMMARIZE(Subscriptions, [CancelledSubscriptions].[Date],"Cancelled Subs",COUNT(Subscriptions[CancelledSubscriptions]),"Cancelled Profiles",SUM(Subscriptions[Number of Profiles]),"Revenue(Cancelled Profiles)",SUM(Subscriptions[Amount])/100,"IsCurrentMonth",
    IF (
        YEAR ( Subscriptions[CancelledSubscriptions].[Date] ) = YEAR ( TODAY() )
            && MONTH ( Subscriptions[CancelledSubscriptions].[Date] ) = MONTH ( TODAY() ),
        "Yes",
        "No"
    ),"IsPreviousMonth",
    IF (
        YEAR ( Subscriptions[CancelledSubscriptions].[Date] ) = YEAR ( TODAY() ) 
            && MONTH ( Subscriptions[CancelledSubscriptions].[Date] ) = MONTH ( TODAY() ) - 1,
        "Yes",
        "No"
    ))

Thanks for helping out!

Need Help
  • amitchandak's avatar
    amitchandak
    3 years ago

    Mitchblue006 , Try measures like

     

    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))

     

     

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

1 Reply

  • amitchandak's avatar
    amitchandak
    Super User
    3 years ago

    Mitchblue006 , Try measures like

     

    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))

     

     

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