Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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 |
---|---|
125 | |
106 | |
99 | |
63 | |
60 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |