Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello all
I hope everyone's ok
I need to know the sum of sales for all years until 2020.
My Dates table has only dates from 1/1/2020. My fact table has dates since 2000. And they're both connected through dates.
It should be simple but a simple measure like this is not working:
I believe i can't do it other way because my dates table hasn't all dates, you know, since 2000
Can you help?
Thanks in advance
Solved! Go to Solution.
Not sure if this would work but you can try
Sales before 2020 = CALCULATE( [Sales], TREATAS( { BLANK() }, 'Date'[Date]) )
Not sure if this would work but you can try
Sales before 2020 = CALCULATE( [Sales], TREATAS( { BLANK() }, 'Date'[Date]) )
Very good. Thanks a lot
User | Count |
---|---|
47 | |
27 | |
23 | |
18 | |
15 |
User | Count |
---|---|
55 | |
34 | |
18 | |
17 | |
15 |