Forum Discussion
Solved
Ignore blank dates
Best regards. I seek to get the value of the last 3 months from my sales table, my table goes: Table date: January 2022 to December 2023 Sales table with values: Sales from January 2022 to date I...
Hi Syndicate_Admin ,
Because you do not provide sample data, so i could only give the solution according to your descriptions.
Please try below dax formula:
Measure = VAR max_date = MAXX ( Sales, Sales[Date] ) VAR tmp = FILTER ( ALL ( Sales ), DATEDIFF ( Sales[Date], max_date, MONTH ) <= 3 ) RETURN SUMX ( tmp, Sales[SAles$] )Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Syndicate_Admin ,
Because you do not provide sample data, so i could only give the solution according to your descriptions.
Please try below dax formula:
Measure =
VAR max_date =
MAXX ( Sales, Sales[Date] )
VAR tmp =
FILTER ( ALL ( Sales ), DATEDIFF ( Sales[Date], max_date, MONTH ) <= 3 )
RETURN
SUMX ( tmp, Sales[SAles$] )
Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.