Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello there,
I’m a new user on Power BI, but so excited about it. Even though I'm still getting familiar with DAX (A beginner).
I would like to achieve the following KPI calculation.
Above, data that really get close to my entire data base. The idea here is to create those columns on yellow; the first one, a flag column that help me out to count how many Back Order I have during a specific period of time; and the second, a column that helps identify which of my orders were actually a back ordered.
Once those columns are created, the idea is to report those BO like this:
Do not know if helps or not, but please realise that the report is based on Reporting Date not in Receipt Date.
You may refer to the following DAX first.
Column = IF ( COUNTROWS ( CALCULATETABLE ( Table1, ALL ( Table1[Receipt Date] ) ) ) = 1, 0, 1 )
Thank you for your reply.
Sadly the formula didnt work for me for now, it created a calculate column with a value of 1 in every row.
The results I want to get its 1 = Unique combination of Order # & Order Line & Receipt date; and a 0 when there is Order &Order Line & with two or more Receipt date.
Thank you,
User | Count |
---|---|
141 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
123 | |
101 | |
71 | |
61 |