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!
Can you please help with DAX query
I need to paste Qty from yesturday to new column against today date
I mean add column with yesturday Qty for each SEG
Thank you!
Solved! Go to Solution.
Hello:
Please see attached filed with solve with calc column and measure. I hope this helps!
https://drive.google.com/file/d/1mih9EiAmzLSP10NGmlOk5nmXhpqZwgpv/view?usp=sharing
ne note - I was using Table Name of data. You can use your table name of AC, so replace "data" in formulas with AC, the name of your table. Thanks..
Hello:
Please see attached filed with solve with calc column and measure. I hope this helps!
https://drive.google.com/file/d/1mih9EiAmzLSP10NGmlOk5nmXhpqZwgpv/view?usp=sharing
@Parfonov , Try like
Last day Qty = sumx(filter(Table, [Shared] = earlier([Shared]) && [Date] = earlier([Date]) -1),[Qty])
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 |
---|---|
44 | |
21 | |
20 | |
15 | |
13 |
User | Count |
---|---|
45 | |
41 | |
39 | |
19 | |
19 |