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.
Hello,
Having trouble with Time Intelligence, likely it is me not comprehending how this works correctly. Below are my formulas.
RevYTD = TOTALYTD([Invoiced],'Calendar'[Date],FILTER('Calendar','Calendar'[Date]<=TODAY()))
Hi @knotpc ,
Have a look at this SQLBI article. You'll probably find the answer there.
In any case, it would certainly help in you provide sample data and the code for the [Invoiced] measure. Otherwise it's a bit hard to know what might be at play. Or, ideally, share the pbix (beware of confidential data).
Thank you for the link. I read that post last week. It does not provide insight into the issue I am having.
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 |
---|---|
113 | |
97 | |
80 | |
69 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |