Learn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register now
Hello,
I´m trying to create a new column (Flag) that show the values 0 or 1.
The value of this column should be 1 if there are one or more rows with Managed > 0 for the same Country on the last 10 days.
For example:
Thanks for your help!
In sql a posible solution is the following pseudocode but I need to do it in DAX.
| User | Count |
|---|---|
| 3 | |
| 2 | |
| 2 | |
| 1 | |
| 1 |
| User | Count |
|---|---|
| 2 | |
| 2 | |
| 2 | |
| 2 | |
| 2 |