Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I have a Fact table with 2 date fields. One is a Date field(20170101) and the other is Month field (201701) and I have created a relationship between this fact table with 2 copies of date table. Like as shown below: Now, I am trying to create one YTD measure on Qty field that should work with Month and Year columns in both date tables (Payment Month and Purchase Date).
I marked Payment Month and Purchase Date tables as date tables in PowerPivot and wrote the following DAX which seems to working in PowerPivot but doesnt work in PowerBI or SSAS tabular for some reason.
Sales_YTD2:=CALCULATE([TotalSales],DATESYTD('PurchaseDate'[Date]),DATESYTD('PaymentMonth'[MonthEndDate]))
(where TotalSales = Sum(Qty))
Any help with the DAX is greatly appreciated.!!!
Hi @errorssuck,
Does your "PaymentMonth" table have a date column which contains continuous dates? Or it only contains month end dates?
As most Time Intelligence Functions (DAX) require an individual and continuous date table to work correctly, please make sure both of your date table have a continuous date column.
Regards
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
101 | |
78 | |
75 | |
49 |
User | Count |
---|---|
145 | |
108 | |
107 | |
89 | |
61 |