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.
Can anyone see why the following fails to change the data lineage from dimdate[date] to bookings[agreement end date]?
Book AvailToRenew=
VAR _MyTable =
ADDCOLUMNS (
SUMMARIZE('Bookings', 'Bookings'[Deal ID]),
"@ATR", sum('Bookings'[Contract Value])
VAR _Dates = VALUES('Bookings'[agreement end date])
RETURN
CALCULATE(
SUMX(_MyTable, [@ATR]),
TREATAS(_Dates, DimDate[Date])
)
2 notes
(1) if I make the TREATAS in a separate measure, the date shift holds. Ther must be something in the virtual table where I'm failing to shift the lineage.
(2) I am having the same issue on similar constructs as the above using USERELATIONSHIP and a physical table relationship.
@charleshale , In this case date table should not be joined with any date of your table
example
CALCULATE(
sum('Bookings'[Contract Value]),
TREATAS(VALUES('Bookings'[agreement end date])
, DimDate[Date])
)
In case of multiple relationship
CALCULATE(
sum('Bookings'[Contract Value]),
UseRelationship([agreement end date], DimDate[Date])
)
Not sure on role of id in this case, As it is sum
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 |
---|---|
96 | |
93 | |
83 | |
70 | |
65 |
User | Count |
---|---|
118 | |
106 | |
93 | |
79 | |
72 |