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.
Hi Filks, Can anyone help me on below two scenarios to write DAX.
1. If RFID is A then cumulative count of Asset(Last Second column) should display is 1, if it's repeats A is 2, A is 3. If it returns B then it will display like 1, C is 1, D is 1. If it all repeats then the number will be changed.
2. If RFID is A comes under with in planned start date and Planned end date then its display as 1, if its repeats also the vale is 1. If RFID comes out under with in planned start date and end date then its retun as 2.
Please help me Dax.
Solved! Go to Solution.
Hi @Anonymous ,
Please refer to my .pbix file. But I don't quite understand the logic of the second formula. Please give me an example.
Best regards,
Lionel Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous ,
Please refer to my .pbix file. But I don't quite understand the logic of the second formula. Please give me an example.
Best regards,
Lionel Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@Anonymous ,The information you have provided is not making the problem clear to me. Can you please explain with an example.
Typically cumm with help date table
Cumm Sales = CALCULATE(SUM(Sales[Sales Amount]),filter(allselected('date'),'date'[date] <=max('date'[date])))
or same table
Cumm Sales = CALCULATE(SUM('Sales'[Sales Amount]),filter(allselected('Sales'),'Sales'[date] <=max('Sales'[date])))
Appreciate your Kudos.
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 |
---|---|
109 | |
98 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
110 | |
91 | |
84 | |
66 |