Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
I have Date column in excel. I imported it in Power BI desktop and try to use it in Date DAX formulas like
Weekday = weekday(table[Date],2)
but I am not able to do so. I am not able to use Date column in measure calculations.
Can you please let me know the reason ?
Solved! Go to Solution.
WEEKDAY() demands a scalar value. You are passing it a column reference. When you ask for WEEKDAY( 'DimDate'[Date] ), you're asking the formula engine to return the weekday of a list of dates? How can it return a single weekday for >1 dates?
What is the purpose of this measure? Typically weekday would be an additional field in the date table, not a measure. You can add a calculated column in your date dimension using the same formula you've proposed. This is because calculated columns are evaluated in row context. In a row context, any column is guaranteed to have one value.
WEEKDAY() demands a scalar value. You are passing it a column reference. When you ask for WEEKDAY( 'DimDate'[Date] ), you're asking the formula engine to return the weekday of a list of dates? How can it return a single weekday for >1 dates?
What is the purpose of this measure? Typically weekday would be an additional field in the date table, not a measure. You can add a calculated column in your date dimension using the same formula you've proposed. This is because calculated columns are evaluated in row context. In a row context, any column is guaranteed to have one value.
Hi,
Thanks for this explanation. I was trying measure calculation on row level context.
Would these additional derived columns affect the performace as I need to calculate few interdependent columns ?
Thank you in advance
@ashishtele It looks like your confusing measures and calculated columns. Read through this for a detailed explanation of both and when/how to use them.
I still haven't got a clue what it is you want to do.
Do calculated columns affect performance? Yes. Do they affect it enough to worry about? Almost definitely not.
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |