The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event: Join us in Stockholm, September 24-27, 2024.
Save €200 with code MSCUST on top of early bird pricing!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
----Fincial Year strats from July 1st
Books Received for Current Year YTD =
CALCULATE(([Books Received]),DATESYTD('Date'[Date],"30/06"))
Books Received previous Year YTD =
Solved! Go to Solution.
Books Received for Previous Year YTD =
CALCULATE(
[Books Received],
DATEADD( DATESYTD( 'Date'[Date], "30/06" ), -1, YEAR )
)
Thanks to the great efforts by MS engineers to simplify syntax of DAX! Most beginners are SUCCESSFULLY MISLED to think that they could easily master DAX; but it turns out that the intricacy of the most frequently used RANKX() is still way beyond their comprehension! |
DAX is simple, but NOT EASY! |
Books Received for Previous Year YTD =
CALCULATE(
[Books Received],
DATEADD( DATESYTD( 'Date'[Date], "30/06" ), -1, YEAR )
)
Thanks to the great efforts by MS engineers to simplify syntax of DAX! Most beginners are SUCCESSFULLY MISLED to think that they could easily master DAX; but it turns out that the intricacy of the most frequently used RANKX() is still way beyond their comprehension! |
DAX is simple, but NOT EASY! |
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the August 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
78 | |
67 | |
52 | |
50 |
User | Count |
---|---|
121 | |
119 | |
77 | |
62 | |
61 |