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.
Hello,
I'm trying to calculate my increase and also my decrease by day.
For example, here I have a Matrix reflecting my value by day and product. What I need is for it to calculate only consider mypositive difference from the previous day for me to have the total increase from yesterday.
I tried using:
Measure = VAR Yesterday=CALCULATE(SUM(Table1[Column1]), PREVIOUSDAY(Table1[Date])) VAR Today= CALCULATE(SUM(Table1[Column1])) RETURN Today-Yesterday |
Solved! Go to Solution.
Hi,
You may download my revised PBI file from here.
Hope this helps.
Hi,
You may download my PBI file from here.
Hope this helps.
Hi,
Share the link from where i can download your PBI file.
Hi,
You may download my PBI file from here.
Hope this helps.
Thanks for your help. Although there is still one thing that I am missing
As you can see in the image below, for March 2nd I got a difference of -34 (BOX IN RED) but I don't need that to be consider as part of my total sum, I just want to sum all those values for that measure that are greater than 0 if it is not greater than 0 i don't want to sum it. So I would be expecting a 280 instead of a 314
Is this possible?
Hi,
You may download my revised PBI file from here.
Hope this helps.
Hi,
May I ask you if there is a possible way to do the same but for the decrease?
If the code appears today but no longer tomorrow I want it to reflect it as a negative.
Here I attached an example
For example the code 888890 had value 72 for March 2nd, but it didn't have any values on March 3rd So i want the measure to return a -72 On March 3rd. An d the same case for March 4th and 5th returning a -125. So that the measure now instead of giving me the total sum for thos positive values I want it to give me only the sum for the negative ones.
Hope this is possible!
Thanks in advance.
Hi,
You may download my PBI file from here.
Hope this helps.
First, Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Second, This looks like a measure totals problem. Very common. See my post about it here: https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376
Also, this Quick Measure, Measure Totals, The Final Word should get you what you need:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907
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 |
---|---|
115 | |
101 | |
78 | |
76 | |
49 |
User | Count |
---|---|
145 | |
108 | |
107 | |
89 | |
61 |