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.
Hi,
I am used to working with Contiguous Dates. We have tables that contain snapshots of a point in time. The table contains the prior day close numbers and the prior month end numbers.
I can get the prior month end just fine without a slicer.
I cannot figure out how to incorporate a slicer and pull the prior month end of the selected date.
I suspect this is simple and my issue is not knowing what DAX to use.
The data is simple:
AR_Snapshot Table | DATES_Table | ||
Effective Date | AR_Amount | CalendarDate | |
1/29/2019 | 10,000 | Contiguous Dates | |
12/31/2018 | 8,000 | ||
11/30/2018 | 11,000 | ||
10/31/2018 | 7,000 | ||
Data Expected with Slicer set to 12/31/18 | |||
Current | Prior | ||
8,000.00 | 11,000.00 |
Solved! Go to Solution.
hi, @Anonymous
You could try to use PREVIOUSMONTH Function to add a measure like this
pre amount = CALCULATE(SUM(Table1[AR_Amount]),PREVIOUSMONTH('Date'[Date]))
Best Regards,
Lin
hi, @Anonymous
You could try to use PREVIOUSMONTH Function to add a measure like this
pre amount = CALCULATE(SUM(Table1[AR_Amount]),PREVIOUSMONTH('Date'[Date]))
Best Regards,
Lin
Covering 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 |
---|---|
114 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
150 | |
115 | |
104 | |
89 | |
65 |