March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
Hi all - still a pretty new user to PBI and DAX but enjoying the learning.
I am trying to calculate the difference of 2 date ranges within the same table containing summed numerical data.
I have one date table and one fact table containing daily numerical data. I have been able to assign summed daily values to 2 separate date ranges through the use of 2 card visuals and 2 date slicers by editing their interactions. However I cannot find a way to calculate the difference between the 2. I have tried using 2 separate measures and a third "difference" measure but that is not viable.
I have also tried using 2 date tables and using the USERELATIONSHIP function to relate the 2nd date table to my second date range, still not working.
If anyone has any ideas that would be a great help.
Solved! Go to Solution.
@DataKev1 - I think you're looking for something similar to this: https://community.powerbi.com/t5/Desktop/Percent-Change-Measure-based-on-Filter/m-p/750463#M361755
@DataKev1 - I think you're looking for something similar to this: https://community.powerbi.com/t5/Desktop/Percent-Change-Measure-based-on-Filter/m-p/750463#M361755
Thanks for the reply @Anonymous I'll give it a try.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
User | Count |
---|---|
125 | |
85 | |
69 | |
54 | |
44 |
User | Count |
---|---|
204 | |
105 | |
99 | |
64 | |
54 |