Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello,
I'm trying to create a dynamic report to show customer revenue data over a period of 6 months that will be automatically updated moving forward. I would like to show when a customer hasn't traded with us for a three month period and for this to be automatically flagged in the report.
I've seen messages about using a measure to flag when a value threshold is reached on other threads, but cannot work this out when it comes to dynamic date ranges.
Any help would be greatly appreciated.
Solved! Go to Solution.
This will calculate how many days since the last sale happened. This assumes a Date table is set up.
Days Since Last Sale = CALCULATE( DATEDIFF(MAX(Sales[Date]),TODAY(),DAY), ALL('Date'[Date]) )
It assumes your fiter context in the table has customers in it. In my sample data, the last sale for Customer 6 was May 15, 2019, so that was 93 days ago. You could then do whatever you want when that hits 90+ days.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingThis will calculate how many days since the last sale happened. This assumes a Date table is set up.
Days Since Last Sale = CALCULATE( DATEDIFF(MAX(Sales[Date]),TODAY(),DAY), ALL('Date'[Date]) )
It assumes your fiter context in the table has customers in it. In my sample data, the last sale for Customer 6 was May 15, 2019, so that was 93 days ago. You could then do whatever you want when that hits 90+ days.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingCovering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
99 | |
73 | |
72 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |