Forum Discussion
Missing values when grouping
Hi Anonymous ,
One possible way to do that is to use DAX formulas to create a new column that assigns each date to a specific interval based on your criteria.
To use DAX formulas, you need to:
Select your data and go to Modeling > New Column.
Create two columns:Date1 = [Date]-10/24Date Interval = SWITCH(TRUE(), 'Table'[Date1] >= DATE(2021,6,1) && 'Table'[Date1] < DATE(2021,10,1), "Jun-Oct 2021", 'Table'[Date1] >= DATE(2021,10,1) && 'Table'[Date1] < DATE(2022,2,1), "Oct-Feb 2022", ...... )Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous ,
One possible way to do that is to use DAX formulas to create a new column that assigns each date to a specific interval based on your criteria.
To use DAX formulas, you need to:
Select your data and go to Modeling > New Column.
Create two columns:
Date1 = [Date]-10/24
Date Interval = SWITCH(TRUE(),
'Table'[Date1] >= DATE(2021,6,1) && 'Table'[Date1] < DATE(2021,10,1), "Jun-Oct 2021",
'Table'[Date1] >= DATE(2021,10,1) && 'Table'[Date1] < DATE(2022,2,1), "Oct-Feb 2022",
......
)
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you Stephen!
This is exactly the solution I ended up going with. It definitely solves the problem.
Doesn't answer the question of why my data isn't being grouped right though, but I'll figure that out another time.
Thanks