Forum Discussion
Issues with Month[today]
I have a formula: 6month Prior = CALCULATE(SUM('Sales Data'[sales_price]), FILTER('Sales Data','Sales Data'[Month Match] = true && 'Sales Data'[Month if Matching] = [Current Month]-6))/ CALCUL...
Anonymous I would recommend using EOMONTH. You can use a pattern such as:
Measure = VAR __Today = TODAY() VAR __Max = EOMONTH( __Today, -6 ) VAR __Min = DATE( YEAR( __EOM6 ), MONTH( __EOM6 ), 1 ) VAR __Table = FILTER( ALL( 'Sales Data' ), [Date] >= __Min && [Date] <= __Max ) VAR __Result = SUMX( __Table, [sales price] ) RETURN __ResultOr do you not have a Date column?
Anonymous I would recommend using EOMONTH. You can use a pattern such as:
Measure =
VAR __Today = TODAY()
VAR __Max = EOMONTH( __Today, -6 )
VAR __Min = DATE( YEAR( __EOM6 ), MONTH( __EOM6 ), 1 )
VAR __Table = FILTER( ALL( 'Sales Data' ), [Date] >= __Min && [Date] <= __Max )
VAR __Result = SUMX( __Table, [sales price] )
RETURN
__ResultOr do you not have a Date column?
Greg_Deckler I do have a date column! I will try this out today and get back to you.
Greg_Deckler this worked perfectly!! How would I update this to count working days for those time frames?
Anonymous There is a NETWORKDAYS function in DAX now, or the old school way: Net Work Days - Microsoft Fabric Community