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.
Hi
I have researched for an answer to this problem but yet to find the right answer.
I have a dataset with columns, ID, Date, Development Type, Delivery Term and would like to see what data has change from one week to the next (if Delivery Term has changed to be specific). All data is within a single table.
I need to be able to show (using conditional formatting, this part I am okay with) rows in a table that have been updated.
Sample Data (visually you can see PRJ003 has had Delivery Term changed, how is the comparison made?)
ID | Date | Development Type | Delivery Term |
PRJ001 | 3/03/2021 | New | Term 1 |
PRJ002 | 3/03/2021 | Improvement | Term 2 |
PRJ003 | 3/03/2021 | Improvement | Term 2 |
PRJ004 | 3/03/2021 | Improvement | Term 3 |
PRJ005 | 3/03/2021 | New | Term 4 |
PRJ006 | 3/03/2021 | New | Term 4 |
PRJ001 | 10/03/2021 | New | Term 1 |
PRJ002 | 10/03/2021 | Improvement | Term 2 |
PRJ003 | 10/03/2021 | Improvement | Term 3 |
PRJ004 | 10/03/2021 | Improvement | Term 3 |
PRJ005 | 10/03/2021 | New | Term 4 |
PRJ006 | 10/03/2021 | New | Term 4 |
Thanks and appreciate the assistance
Solved! Go to Solution.
This will give you a column of the previous value:
DiffFromPrvWeek = VAR _id = TablePrj[ID]
VAR _term = TablePrj[Delivery Term]
VAR _date = TablePrj[Date]
RETURN
CALCULATE(MIN(TablePrj[Delivery Term]), FILTER(ALL(TablePrj), TablePrj[ID] = _id && TablePrj[Date] = _date -7))
You can use it to create another column to signal a difference (from delivery term) or use an IF statement within the formula.
Hello how about I need to compare recipes from the same table, by different scepters, and material to see if they match by the amount loaded in the components:
and put in a column if it matches or not.
This will give you a column of the previous value:
DiffFromPrvWeek = VAR _id = TablePrj[ID]
VAR _term = TablePrj[Delivery Term]
VAR _date = TablePrj[Date]
RETURN
CALCULATE(MIN(TablePrj[Delivery Term]), FILTER(ALL(TablePrj), TablePrj[ID] = _id && TablePrj[Date] = _date -7))
You can use it to create another column to signal a difference (from delivery term) or use an IF statement within the formula.
User | Count |
---|---|
123 | |
69 | |
67 | |
58 | |
52 |
User | Count |
---|---|
183 | |
92 | |
67 | |
62 | |
52 |