The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Data Points:
"OktoInvoiceDate," "OKtoInvoiceDate+90", "SaleDate", "Sale$"
I need to calculate the SUM(Sale$) that took place during the time frame between "OktoInvoiceDate" and "OktoInvoiceDate+90"
These need to be measures
I can't figure it out!
Hi @bhmiller89,
If I understand you correctly, you should be able to follow steps below to get your expected result.
1. Add an individual Calendar table if you don't have one yet.
Date = CALENDARAUTO()
2. Then you can use the formula below to create a measure to calculate the SUM(Sale$) for a selected date that took place during the time frame between "OktoInvoiceDate" and "OktoInvoiceDate+90".
measure = VAR currentDate = MAX ( 'Date'[Date] ) RETURN CALCULATE ( SUM ( Table1[Sale$] ), FILTER ( Table1, Table1[OktoInvoiceDate] <= currentDate && Table1[OktoInvoiceDate+90] >= currentDate ) )
Regards
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
100 | |
94 | |
80 | |
63 | |
56 |
User | Count |
---|---|
248 | |
122 | |
110 | |
77 | |
70 |