We're giving away 30 tickets for FREE! Share your story, your vision, or your hustle and tell us why YOU deserve a ticket.
Apply nowWin a FREE 3 Day Ticket to FabCon Vienna. Apply now
Hello All,
I'm getting this error, when trying to create a calculated columns.
I'm connected to two data sources: a live connection to Analysis service and an imported table.
here is the dax that is causing the issue:
CALCULATE(
SUM(table 1 [cost]),
table 1 [ID] = CurrentID,
table 1 [date] >= datecurrent,
table 1 [date] <= FirstDateOverCostAB
)
Note: Table 1 has over 10 million IDs.
Appreciate your help!
Hi @hiba_aziz
I am not sure about CurrentID, datecurrent, FirstDateOverCostAB you are using, are these variable in DAX
Please create a PBIX with few sample record and share the google drive or dropbox or onedrive link
Proud to be a Super User! | |
User | Count |
---|---|
62 | |
59 | |
46 | |
35 | |
31 |
User | Count |
---|---|
85 | |
71 | |
57 | |
51 | |
46 |