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 have two columns, one with the date and the other in year-month format, and I want to add a third one that is a counter for each day that goes by, and when it is a new month that it restarts. I was able to do it in total, but not that it restarts per month, and I'm getting very complicated.
Date | Month |
2022/06/01 | 2022/06 |
2022/06/02 | 2022/06 |
... | ... |
2022/06/01 | 2022/07 |
Date | Month | count |
2022/06/01 | 2022/06 | 1 |
2022/06/05 | 2022/06 | 2 |
... | ... | ... |
2022/06/01 | 2022/07 | 1 |
Solved! Go to Solution.
HI @nicolasvc,
You can try to use the following measure formula to get the count based on the current date and current month group:
formula =
CALCULATE (
COUNT ( Table[Date] ),
FILTER ( ALLSELECTED ( Table ), [Date] <= MAX ( Table[Date] ) ),
VALUES ( Table[Month] )
)
Regards,
Xiaoxin Sheng
HI @nicolasvc,
You can try to use the following measure formula to get the count based on the current date and current month group:
formula =
CALCULATE (
COUNT ( Table[Date] ),
FILTER ( ALLSELECTED ( Table ), [Date] <= MAX ( Table[Date] ) ),
VALUES ( Table[Month] )
)
Regards,
Xiaoxin Sheng
Hi we wnat to help but please provide a lot more examples not just 3 dates and take care to avoid typing mistakes
Explain the missing dates. Why does it jump from 22/06/01 to 2022/06/05 ?
And why is 2202/06/01 in month 2022/06 and 2022/07. It does not make sense and looks like typing mistakes.
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 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |