Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hello all,
I need help in trying to find difference in a measure when user select 2 date or year/month. Just getting blank, not sure if the formula or can you find difference in a measure.
Please help and advise. Thanks.
Below is link to sample pbix file.
https://www.dropbox.com/s/yq7os1gkf9e6y0s/Find%20difference%20of%20selected%20dates.pbix?dl=0
Difference measure
Matrix showing Blank for Difference:
Solved! Go to Solution.
Hi,
Download the PBI file from here. The answer is 0 in the Diff column because even in a different year, the Region and Site name combination changes.
Hi,
Download the PBI file from here. The answer is 0 in the Diff column because even in a different year, the Region and Site name combination changes.
You are welcome.
User | Count |
---|---|
123 | |
69 | |
67 | |
58 | |
52 |
User | Count |
---|---|
183 | |
92 | |
67 | |
62 | |
53 |