Forum Discussion
Solved
DAX: Cumulative Comparison (Count row from table visual)
Hi, Community. This is my first time post on community. Please advice if i'm doing something wrong. I need some help for DAX to calculation on my report it a little bit complicate but I'll t...
zeroblack7 File is attached below my signature, I have also included a custom Date table.
GrowthStatusCount = VAR CurrentDate = MAX ( Dates[Date] ) VAR LastMonday = CurrentDate - WEEKDAY ( CurrentDate, 3 ) VAR Result = FILTER ( ADDCOLUMNS ( CALCULATETABLE ( SUMMARIZE ( fSalesTable, Dates[Date], Dates[Day Name], dCompanyGroup[Company] ), Dates[Date] = LastMonday ), "@Growth Status", [GrowthStatus] ), NOT ISBLANK ( [@Growth Status] ) ) RETURN COUNTROWS ( Result )
AntrikshSharma
Community Champion
Community Championzeroblack7 File is attached below my signature, I have also included a custom Date table.
GrowthStatusCount =
VAR CurrentDate =
MAX ( Dates[Date] )
VAR LastMonday =
CurrentDate - WEEKDAY ( CurrentDate, 3 )
VAR Result =
FILTER (
ADDCOLUMNS (
CALCULATETABLE (
SUMMARIZE ( fSalesTable, Dates[Date], Dates[Day Name], dCompanyGroup[Company] ),
Dates[Date] = LastMonday
),
"@Growth Status", [GrowthStatus]
),
NOT ISBLANK ( [@Growth Status] )
)
RETURN
COUNTROWS ( Result )
Thank you AntrikshSharma This is what i'm looking for. Your Dax is quite complex to me but I will learn a lot from your . Thanks again.
Jay
- AntrikshSharma
zeroblack7 You're welcome! Thanks for creating a detailed post and sharing what you have tried so far. Everything was easy to understand.