Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
Hi,
I am using the following formula to calculate YTD totals but I keep getting the total year number instead of YTD:
Hi @Anonymous ,
Just looking at your TOTALYTD dax expression, I think it is expecting a 3rd argument.
You can also achieve this without using TOTALYTD.
Can you try modifying your DAX as follows:
YTD_Tx.Sales = CALCULATE(
SUM(TS(Sales), DATESYTD('DateTable'[Date]), TS[Cycle]= "CM", TMS[Business]= "Tx"
)
Try referring the folllowing article on why TOTALYTD can have issues:
https://www.sqlbi.com/blog/marco/2018/08/10/the-hidden-secrets-of-totalytd/
If this helps and resolves the issue, appreciate a Kudos and mark it as a Solution! 🙂
Thanks,
Pragati
Thank you for your response. I tried the formula but it is still giving the total sales and not YTD sales. I tried the formulas in the link as well but getting same result with them too. I checked the relationship between the two table and it also exists. So i really can't figure out what the issue is 😞
HI @Anonymous ,
Is your date table correct? I mean does it have date values up-to-date?
If this helps and resolves the issue, appreciate a Kudos and mark it as a Solution! 🙂
Thanks,
Pragati
User | Count |
---|---|
11 | |
11 | |
8 | |
6 | |
5 |
User | Count |
---|---|
25 | |
19 | |
16 | |
10 | |
7 |