Forum Discussion

CAB80's avatar
CAB80
Frequent Visitor
6 years ago

Calculated Column in Direct Query not working

Hello,   I'm new to this forum and Power BI, so please go easy on me 😁   I've been going nuts all afternoon, because a simple calculated column(as below) works in imported mode but not in direct...
Need Help
amitchandak's avatar
amitchandak
Super User
6 years ago

CAB80 

Calculated column does not work in Direct Query mode. You have work in terms of measure

Try like


CalSeasonStartDate =
CALCULATE(Min('Calendar'[Date]),
filter(all(bi_Grader_BatchV), not(isblank(bi_Grader_BatchV[TotalBinWeight])) && bi_Grader_BatchV[Season] = max('Calendar'[Season])))

Refer how i done it with measure : https://community.powerbi.com/t5/Community-Blog/Decoding-Direct-Query-in-Power-BI-Part-1-Time-Intelligence-in/ba-p/922885

https://community.powerbi.com/t5/Community-Blog/Decoding-Direct-Query-in-Power-BI-Part-2-Date-Difference-Across/ba-p/934397#M451

You need create measure and take care of context

CAB80's avatar
CAB80
Frequent Visitor
6 years ago

Thanks for the prompt reply, but this did not work.  It only gives me the start date across all seasons, not for reach season.See below.  So its grabbing the Min date, but not for each of the seasons.  For simplicity I only have two tables here, my calendar table and the bi_Grader_BatchV table which are lnked via date and packdate respectively.  My code worked perfectly as a column in the imported file.  The reason I wanted a column was so that I could easily reference any record to the start/end date of each season.

 

Any other help would be much appreciated.