Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
How to calculate YTD data untill the latest full month. The data is on month base and not on date base
@Anonymous
You try the
TOTALYTD(SUM('table'[value]), 'dates'[Date])
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Thnx Fowmy for the quick anwser. For the Month I use a simple table and the problem is that this is not a date table but a text table.
Hi, @Anonymous ;
If this is not a text type, you can try to use CONVERT() to convert the text type to a date type.such as:
Column = CONVERT([Column1],DATETIME )
If it doesn’t solve your problem, can you share pbix or screenshots whitout any sesentive information, and the results you want to output?
User | Count |
---|---|
141 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
123 | |
101 | |
71 | |
61 |