Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi Team,
I need current 7 days Vs previous 7 days comparsion data .
need data as shown in image.
Thanks,
Arvind
Solved! Go to Solution.
@Arvind_123
Use these two measures:
Sales Last 7 Days =
Var __Last7Days = DATESINPERIOD( 'Date'[Date] , MAX('Date'[Date]) , -7 , DAY )
Var __Result = CALCULATE( [Sales Amount] , __Last7Days)
RETURN
__Result
Sales Previous 7 Days =
Var __Last7Days = DATESINPERIOD( 'Date'[Date] , MAX('Date'[Date]) - 7 , -7 , DAY )
Var __Result = CALCULATE( [Sales Amount] , __Last7Days)
RETURN
__Result
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
@Arvind_123
Use these two measures:
Sales Last 7 Days =
Var __Last7Days = DATESINPERIOD( 'Date'[Date] , MAX('Date'[Date]) , -7 , DAY )
Var __Result = CALCULATE( [Sales Amount] , __Last7Days)
RETURN
__Result
Sales Previous 7 Days =
Var __Last7Days = DATESINPERIOD( 'Date'[Date] , MAX('Date'[Date]) - 7 , -7 , DAY )
Var __Result = CALCULATE( [Sales Amount] , __Last7Days)
RETURN
__Result
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
User | Count |
---|---|
77 | |
74 | |
62 | |
61 | |
45 |
User | Count |
---|---|
108 | |
100 | |
91 | |
83 | |
61 |