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 there,
Could you please help me out?
Link to the files: https://1drv.ms/u/s!AvDjQoL_zmjliHROT3e-Y6s2FSmD?e=fFX1lc
Situation:
This should be the outcome:
Thanks in advance..!
Solved! Go to Solution.
I see your expected solution. It seems that is impossible to make the table exactly same as your expected outcome. You cannot have blank in the datesigned and maxenddate like your expected outcome with the features in Power BI Desktop.
Best regards,
Paul
@JohanData
I created SpendCum and Project results columns in the fact table in my solution. Since you are including columns from two tables in Power bi, you cannot leave blanks and make the table exact same as your expected outcomes.
SpendingCum =
CALCULATE (
SUM ( 'Fact'[SpentAmount] ),
FILTER (
ALLEXCEPT('Fact','Dimension'[ParentProjectNr]),
[Date] <= EARLIER ( 'Fact'[Date] )
),
'Fact'[Date] >= RELATED ( 'Dimension'[DateSigned] ),
'Fact'[Date] <= RELATED ( 'Dimension'[MaxDateEndProject] )
)
Project result =
CALCULATE (
SUM ( 'Dimension'[Price] ) - LASTNONBLANK ( 'Fact'[SpendingCum], "" ),
FILTER ( 'Fact', LASTDATE ( 'Date'[Date] ) )
)
Here is the pbix if needed: https://qiuyunus-my.sharepoint.com/:u:/g/personal/paul_qiuyunus_onmicrosoft_com/EdXN14MBisFInuK7Lr2L...
Best,
Paul
@V-pazhen-msft thanks!
Unfortunately, this is not what I'm looking for. I reshaped my files. This should be the outcome (screenshot +attached files):
Link: https://1drv.ms/u/s!AvDjQoL_zmjliQLeHwlgFVgk6kvD?e=LRAd5i
I see your expected solution. It seems that is impossible to make the table exactly same as your expected outcome. You cannot have blank in the datesigned and maxenddate like your expected outcome with the features in Power BI Desktop.
Best regards,
Paul
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 |
---|---|
112 | |
100 | |
80 | |
64 | |
57 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |