The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hi All,
I have an issue regarding Last YTD, I have this sample data
I would like to achieve the total data 2022 till Aug.. because the current year data only available till August 2023.
I understand to use DatesYTD function but when I tried to use with flexible date somehow not working.
Below is the DAX I tried
m_LY FY = CALCULATE(SUM(Value), DATESYTD(dateadd('Date'[Date],-1,Year),FORMAT(MAX(Completions[Training Record Completed Date]),"MM/YY")))
Would appreciate any help provided! Thank you!
Solved! Go to Solution.
Hi,
PBI file attached.
Hope this helps.
Try the following code, and see if is what you need
m_LY FY =
CALCULATE(
SUM(Value),
SAMEPERIODLASTYEAR(
'Date'[Date]
)
)
Thanks for replying, I'm using the calculation but seems it's still showing me "Total all 2022"
While I am trying to achieve total 3774
as reference I put the pbix file here PBI File
I would like to use "Date" Table to show the dates.
Thank you so much for the help, so I should create the "Date" Table following the Transaction table is it?
Thank you for help!
You are welcome. Yes.
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 June 2024 Power BI update to learn about new features.
User | Count |
---|---|
99 | |
93 | |
81 | |
63 | |
56 |
User | Count |
---|---|
248 | |
123 | |
111 | |
78 | |
74 |