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.
I made certain calculations in Tableau which I am trying to replicate in DAX, can anyone please help me do so.
The sample data snapshot is attached below, e.g for each Id there are multiple dates for a new request so, we just want to pick the last date or max date.
The fourth column is expected output for first calculation.
In the Second calculation, 'Assigned to Vendor Reece ' is one of the dell names in the table
1.Max_Modified_Date
DATE({ FIXED [dell RequestId Name],[Dell Name]:MAX([Modified On])})
2. Assigned to Vendor for Reece
{Fixed [dell RequestId Name]: MAX( IF [Dell Name]= "Assigned to Vendor for Recce" THEN [Modified Date_max]
END)
Try This :
Modified Date_max] = Max_(CALCULATE(MAX([[Modified On]),FILTER(tablename,[dell RequestId Name]=EARLIER('[dell RequestId Name])),FILTER(tablename,[[Dell Name]]=EARLIER([Dell Name]))
This work sames as the calculation you created for tableau.
Not exactly certain what you are going for here but if you are looking for the MAX between multiple columns, then you can use my Quick Measure here: https://community.powerbi.com/t5/Quick-Measures-Gallery/Multi-Column-Aggregations-MC-Aggregations/m-...
Hi Greg,
This is very different from what I want to calculate!
For each Request Id, there are a certain set of steps followed, which are mentioned in the column of Dell name.
And, each step has its modified date, therefore, in this data one Request Id, for each step can have multiple entries from which I need to pick the last modified date of each step in each ID.
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 |
---|---|
114 | |
101 | |
78 | |
75 | |
49 |
User | Count |
---|---|
145 | |
108 | |
107 | |
89 | |
61 |