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.
Struggling with this one. I have a dataset of transactions that occur either weekly or fortnightly, some manual and some auto, with different types on different phases. I'm trying to flag true/false of the transaction is the last auto transaction for that group for that month:
Paygroup Type Date True/False
P1F Auto 03/09/17 False
P1F Auto 17/09/17 True
P1F Manual 17/09/17 False
P1W Auto 03/09/17 False
P1W Auto 10/09/17 False
P1W Auto 17/09/17 False
P1W Auto 24/09/17 True
P1M Auto 15/09/17 True
P2F Auto 10/10/17 False
P2F Auto 24/10/17 True
Solved! Go to Solution.
You may refer to the following DAX that adds a calculated column.
Column = Table1[Type] = "Auto" && RANKX ( FILTER ( Table1, Table1[Paygroup] = EARLIER ( Table1[Paygroup] ) && Table1[Type] = EARLIER ( Table1[Type] ) && YEAR ( Table1[Date] ) = YEAR ( EARLIER ( Table1[Date] ) ) && MONTH ( Table1[Date] ) = MONTH ( EARLIER ( Table1[Date] ) ) ), Table1[Date], , DESC, DENSE ) = 1
You may refer to the following DAX that adds a calculated column.
Column = Table1[Type] = "Auto" && RANKX ( FILTER ( Table1, Table1[Paygroup] = EARLIER ( Table1[Paygroup] ) && Table1[Type] = EARLIER ( Table1[Type] ) && YEAR ( Table1[Date] ) = YEAR ( EARLIER ( Table1[Date] ) ) && MONTH ( Table1[Date] ) = MONTH ( EARLIER ( Table1[Date] ) ) ), Table1[Date], , DESC, DENSE ) = 1
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 |
---|---|
111 | |
97 | |
80 | |
69 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |