Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I have this data: Where I have found workaround but need permanant solution.
Original Data - from Oracle db which pulls last 4 days of data | |||||
Column 1 | Count (IDs) | Date | |||
A | 56 | 22-Apr | |||
B | 789 | 22-Apr | |||
C | 2312 | 22-Apr | |||
D | 3221 | 22-Apr | |||
A | 23-Apr | ||||
B | 3454 | 23-Apr | |||
C | 231 | 23-Apr | |||
D | 3232 | 23-Apr | |||
A | 4856 | 24-Apr | |||
B | 232 | 24-Apr | |||
C | 353 | 24-Apr | |||
D | 1254 | 24-Apr | |||
A | 25-Apr | ||||
B | 2134 | 25-Apr | |||
C | 342 | 25-Apr | |||
D | 354 | 25-Apr |
I have used pivot table function to get below table: After pivot I have manually selected all dates as my columns.
This is expected output.
Output | ||||
Column 1 | 22-Apr | 23-Apr | 24-Apr | 25-Apr |
A | 56 | 4856 | ||
B | 789 | 3454 | 232 | 2134 |
C | 2312 | 231 | 353 | 342 |
D | 3221 | 3232 | 1254 | 354 |
But when I refresh data next day, dashboard will be broken, since I am manually selecting days to display last 4 days of data in Power BI.
Can you help me achieve this without manually adding dates everyday?
Thank you in advance.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.