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 All,
What I need is a column with the numbers per date (that I have). In column 2 I'm looking for the value of the previous datetime. See column "Needed".
For previous I use now:
CALCULATE(SUM(OutputSQL[OMZET]);FILTER(ALL(OutputSQL[PEILDATUM]); OutputSQL[PEILDATUM] < MAX(OutputSQL[PEILDATUM])))
I know I add up the numbers less than the date but I don't know how to use only the previous date. I've tried EARLIER but got stuck.
Any directions?
Solved! Go to Solution.
You may add an index column in Query Editor, then use DAX below to add a calculated column.
Column = LOOKUPVALUE ( OutputSQL[OMZET], OutputSQL[Index], OutputSQL[Index] - 1 )
You may add an index column in Query Editor, then use DAX below to add a calculated column.
Column = LOOKUPVALUE ( OutputSQL[OMZET], OutputSQL[Index], OutputSQL[Index] - 1 )
Thanks, Indexing did the trick.
I’m sorry but forgot to mention that my datetime column contains all the mentioned values. They are nog unique. In Total there are more than 4000 records.
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 |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
93 | |
84 | |
66 |