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.
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)
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 |
---|---|
108 | |
106 | |
88 | |
74 | |
69 |
User | Count |
---|---|
123 | |
112 | |
95 | |
83 | |
73 |