The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hi all,
I need some help please. I think have this basic issue embedded in a more complex forumla.
I have the following columns: Date 1, Date 2, Amount.
I want to add a column with the sum of the amount when any Date 2 is larger (or equal) to the specific row's Date 1.
This is what I want (excel representation):
Please help with suggestions that I can use in DAX to add a column with the above result.
Thanks in advance
Solved! Go to Solution.
@JohannSteyn , Sorry, I think I reverted the logic
new column =
var _date = [Date1]
return
sumx(filter(Table, Table[Date2] >=_Date),[Amount])
@JohannSteyn , Try a new column like
new column =
var _date = [Date2]
return
sumx(filter(Table, Table[Date1] <=_Date),[Amount])
@amitchandak Thanks for the suggestion. Unfortuntely that does not work (see below). Any other ideas?
@JohannSteyn , Sorry, I think I reverted the logic
new column =
var _date = [Date1]
return
sumx(filter(Table, Table[Date2] >=_Date),[Amount])
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
102 | |
82 | |
62 | |
56 |
User | Count |
---|---|
254 | |
119 | |
115 | |
99 | |
71 |