Forum Discussion
DAX YTD Function with Slicer
Hi, I am realtively new user of power BI. I have two tables -1.Forecast 2. Calender Lookup in my model and i had created 'many to one' cardinality between them. Now wanted to create DAX function to ...
Anonymous you don't need this code for YTD
,FILTER(Lookup,Lookup[Date]<=[Max])Also did you marked the calendar lookup table as a date table?
Check my latest blog post Comparing Selected Client With Other Top N Clients | PeryTUS I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
Anonymous great. Although it doesn't matter you marked your reply as an answer. Always marked the correct reply as an answer so that others can find the solution. FYI
Yes i did, and it's working. Thank you so much.