Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
hello everyone,
I have a table with the following columns and measure:
I would need a measure (New Measure) to calculate the difference in Budget between the last available Report Date (9/30/2023) and the previous date right before (09/15/2023). The desired result is shown in the gree column above...any help from the experts will be really apprecited! thanks!
Solved! Go to Solution.
Hi,
Create a Calendar Table with a relationship (Many to One and Single) from the Report date column to the Date column of the Calendar Table. To your visual, drag Date column from the Calendar Table. Assuming Budget is a measure that you have already written, write this measure
Measure = [Budget]-calculate([budget],calculatetable(lastnonblank(Calendar[Date],calculate([budget])),datesbetween(calendar[date],minx(all(calendar[Date]),calendar[date]),min(calendar[date])-1)))
If this does not help, then share the download link of the PBI file.
Hi,
Create a Calendar Table with a relationship (Many to One and Single) from the Report date column to the Date column of the Calendar Table. To your visual, drag Date column from the Calendar Table. Assuming Budget is a measure that you have already written, write this measure
Measure = [Budget]-calculate([budget],calculatetable(lastnonblank(Calendar[Date],calculate([budget])),datesbetween(calendar[date],minx(all(calendar[Date]),calendar[date]),min(calendar[date])-1)))
If this does not help, then share the download link of the PBI file.
User | Count |
---|---|
98 | |
91 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
66 |