Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
User | Count |
---|---|
93 | |
87 | |
77 | |
72 | |
66 |
User | Count |
---|---|
116 | |
107 | |
88 | |
65 | |
63 |