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.
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.
https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523