topic Re: Creating a measure that shows the difference for the first visible date before the current date in DAX Commands and Tips

Creating a measure that shows the difference for the first visible date before the current date

Anonymous — Tue, 17 Dec 2024 17:52:58 GMT

I have a simple bar chart that shows a value for each date.
I want to create a measure, to be used in the tooltip, that will show the difference in value between the last visible date in the chart.
If I'm filtering the chart so it only shows mondays, I want the tooltip for each day to show the difference from the current date to the last monday.

For instance, in scenario 1, the tooltip for 16/12 (dd/mm) will show 39.72 - 16.75 = 22.7. Notice that 16.75 is the value for the monday before.
But if I'm filtering like in scenario 2, the tooltip for 16/12 will show 39.2 - 34.9 = 4.3. Notice that 34.9 is the value for the previous day.

Scenario 1

Scenario 2

Re: Creating a measure that shows the difference for the first visible date before the current date

lbendlin — Wed, 18 Dec 2024 01:37:59 GMT

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Please show the expected outcome based on the sample data you provided.

Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523