Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hi
I am working wit tabular model and the data comes via our datawarehouse. There are fact tables connected to a date table. Linked by Date Value.
When I bring in Year Month as the rows (for example), all my YTD functions do not work, and they will instead show the value for each month.
When I just use the date field - the YTD amounts calculate correcly. Why would my month slicer be casuing these issues?
Solved! Go to Solution.
Hey @AndySmith ,
I tried to replecate on my model.
It looks good to me.
I tried TOTALYTD([Qty], 'Date'[Date], "30/06") -> Comm (1)
and
Seems to be smtg with your fields in your Date table.
What is "Date Value" represents?
Regards
Thanks for the reply. The left hand table - which uses dates as teh rows works fine. Its when I bring in months that the YTD no longer works. I woul dexpect that when Months are applied in the rows - the YTD formual would still calc. - so it would a running total of the month sales.
YTD formula is simple :
Hey @AndySmith ,
I tried to replecate on my model.
It looks good to me.
I tried TOTALYTD([Qty], 'Date'[Date], "30/06") -> Comm (1)
and
Seems to be smtg with your fields in your Date table.
What is "Date Value" represents?
Regards
Thanks. There was mismatch of data types for the date field. ALl fixed. Thanks agin
I can see on the left hand side your date is accumulated with a month.
You can see there is a break between 30/06/2023 and 01/07/2023.
June is ready accumulated then july starts with accumulation.
Therefore it seems to give you a correct result on the month-level.
What is your intension / expectation on the result of your YTD?
Can you pls provide your YTD formula?
Regards
Check out the September 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
114 | |
95 | |
90 | |
35 | |
35 |
User | Count |
---|---|
154 | |
102 | |
82 | |
64 | |
54 |