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.
Hello All -- New Power Bi user here and training in the coming weeks. I was tasked with the following but all attempts so far have not worked. I've tried using a combination of Column formulas, measure formulas, and table formulas with no success. Where do I go from here?
I am attempting to return in my report values for the most recent submission as well as the second to last submission by Item. See screenshot. Any help is much appreciated!
Solved! Go to Solution.
Please try these MEASURES for current date and price
DateCurrent = MAX ( Table1[Date] )
PriceCurrent = VAR CurrentDate = [DateCurrent] RETURN CALCULATE ( SUM ( Table1[Price] ), Table1[Date] = CurrentDate )
And try these MEASURE for Previousdate and PreviousPrice
DatePrevious = VAR currentdate = [DateCurrent] RETURN CALCULATE ( MAX ( Table1[Date] ), Table1[Date] < currentdate )
PricePrevious = VAR PreviouDate = [DatePrevious] RETURN CALCULATE ( SUM ( Table1[Price] ), Table1[Date] = PreviouDate )
Please try these MEASURES for current date and price
DateCurrent = MAX ( Table1[Date] )
PriceCurrent = VAR CurrentDate = [DateCurrent] RETURN CALCULATE ( SUM ( Table1[Price] ), Table1[Date] = CurrentDate )
And try these MEASURE for Previousdate and PreviousPrice
DatePrevious = VAR currentdate = [DateCurrent] RETURN CALCULATE ( MAX ( Table1[Date] ), Table1[Date] < currentdate )
PricePrevious = VAR PreviouDate = [DatePrevious] RETURN CALCULATE ( SUM ( Table1[Price] ), Table1[Date] = PreviouDate )
User | Count |
---|---|
96 | |
87 | |
78 | |
72 | |
68 |
User | Count |
---|---|
113 | |
105 | |
84 | |
65 | |
64 |