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.
Hi Everyone,
I am trying to label all transactions at row level which should be dynamic basis selection of date.
For eg.
My original data table is in below format
Invoice | Date |
1 | 01/01/2019 |
2 | 16/01/2019 |
3 | 31/01/2019 |
4 | 15/02/2019 |
5 | 02/03/2019 |
I am trying to create a column which should show results as below:-
if the date selected is 31/03/2019
Invoice | Date | Status |
1 | 01/01/2019 | Overdue |
2 | 16/01/2019 | Overdue |
3 | 31/01/2019 | Overdue |
4 | 15/02/2019 | Overdue |
5 | 02/03/2019 | Overdue |
if the date selected is 31/01/19
Invoice | Date | Status |
1 | 01/01/2019 | Overdue |
2 | 16/01/2019 | Overdue |
3 | 31/01/2019 | Overdue |
4 | 15/02/2019 | Current |
5 | 02/03/2019 | Current |
hi, @Anonymous
I added a date table as the selection of the dates and created a measure to show the overdue and current situation.
Please refer to the screenshot below.
Is there any other way to create the same calculation using Column. Basically, I want to categorize all transactions at row level to show % Overdue and % Current. I understand it will not be possible using a measure.
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 |
---|---|
107 | |
99 | |
78 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |