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.
I have 2 Tables, A & B.
Table A is constantly changing on a weekly basis, whereas Table B will have records of date and sum. E.g.
Table B
18.01.2018, 2
19.01.2018, 3
and so on, so we have a trend of a weekly value
I'm having a difficult time writing an IF statement in Advaned Editor to see if today's date already exist, then ignore, if today's datedoes not exist, then calculate sum in Table A and create a new row in Table B.
I'm sure this could be resolved in the backend but it's what I have at the moment.
Solved! Go to Solution.
You may perform Group By operation first, then refer to the code in this thread.
You may perform Group By operation first, then refer to the code in this thread.
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 |
---|---|
110 | |
99 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
110 | |
91 | |
84 | |
66 |