User Profile
elyfiora
Regular Visitor
Joined 6 years ago
User Widgets
Contributions
Re: How to report last value available
Hello, thanks. Calendar contains all the dates, one for each day/month/year. My results is (error in previous post): Date bFP Project Jan-21 100 A Feb-21 A Mar-21 A Apr-21 A May-21 120 A Expected results are: Date bFP Project Jan-21 100 A Feb-21 100 A Mar-21 100 A Apr-21 100 A May-21 120 A1.2KViews0likes5CommentsHow to report last value available
Hello, I have one table called 'Cast' with: Project Date bFP A 01-01-2021 100 A 01-05-2021 120 Then I have the 'Calendar' Table linked to 'Cast' using 'data'. The expected results is: Date bFP Project Jan-21 100 A Feb-21 100 A Mar-21 100 A Apr-21 100 A May-21 100 A So for missing Date I need to see the last availabe value. I elaborated the formula below: CastBFP:=SUMX ( SUMMARIZE ( Cast, Cast[sk_CastProject], "myXBFP", CALCULATE ( CALCULATE ( MAX ( Cast[bFP] ), LASTNONBLANK ( Calendar[Data], CALCULATE ( MAX ( Cast[bFP] ) ) ) ), ), [myXBFP] ) But results is: Date bFP Project Jan-21 100 A Feb-21 A Mar-21 A Apr-21 A May-21 100 A So I do not have values for Feb, Marc and April. How can I fix? Thanks Elisa1.3KViews0likes9CommentsScatter plot, trend line and R-squared value
Hello, I'm performing a scatter plot on Power BI Desktop with X axis, Y axis, Legend and Size values. I noticed that into analytics panel the trend line is not available (I can select only X-Axis and Y-Axis constant line, min and max line, average line, symmetry shading and ratio line). If I remove size into scatter plot the trend line becomes available. Is there any possibility to show the trend line even if I add size info scatter plot ? In addition is there the possibility to show the R-Squared value when the trend line is shown? Thanks in advance for the collaboration Elisa4.9KViews0likes4Comments
Data Privacy
Microsoft Fabric Community and Privacy
To learn more about how we manage your data, please review the Microsoft Fabric Community Data Privacy guide.