I have several important date fields that I need to report on based on how old the date is. In our CRM (Dynamics) there is a neat filter for older than X months/weeks/days etc. I am finding this very difficult to reproduce in Power BI.
So my example would be I have a table of customers and in this table there is a date field for the last time they had services. I need to report all the customers who haven’t had services for more than 6 months, 6-12 months and 12-24 months.
Anyone encountered this scenario or have a solution?