Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Hi.
I cannot figure out how to sum column C from Table 1 based on the condition that column B values fit the interval (Column I and J)
Could anyone help me solve that problem? Everytime I try to either create a new column or a new measure, DAX does not allow me to use the variables I need to implement the maths.
Thank you in advance
Solved! Go to Solution.
@JMSNYC - Should be as a column:
Actual Revenue = SUMX(FILTER(RELATEDTABLE('DAILY REVENUES'),[Date Rev.]>=[Tender Start Date] && [Date Rev.]<=[Tender End Date]),[Revenue])
If that does not work please @ me
I did confirm this in the attached PBIX file below sig. Table (23), Table (23a), Table (23b)
@JMSNYC , Try a new column like this Tenders Table
sumx(filter(DailyRevenue, Tenders[TenderStartDate]<=DailyRevenue[DateRev]
&& Tenders[TenderEndtDate]>=DailyRevenue[DateRev] && DailyRevenue[CustomerUID] = Tenders[CustomerUID]),DailyRevenue[Revenue])
@JMSNYC - Should be as a column:
Actual Revenue = SUMX(FILTER(RELATEDTABLE('DAILY REVENUES'),[Date Rev.]>=[Tender Start Date] && [Date Rev.]<=[Tender End Date]),[Revenue])
If that does not work please @ me
I did confirm this in the attached PBIX file below sig. Table (23), Table (23a), Table (23b)
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
117 | |
109 | |
106 | |
92 | |
68 |
User | Count |
---|---|
167 | |
130 | |
129 | |
95 | |
91 |