Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi,
I have added a calculated column 'LY'. But it is giving the blank values.
(Note : I have made a MEASURE in the same way, which is working. But I need a column)
Please let me know, if any modification to be done.
Solved! Go to Solution.
Hi @seenai ,
The time intelligence function PREVIOUSYEAR() requires a continous date column, I would suggest you creating another calendar table with the CALENDARAUTO() function.
Best Regards,
Teige
Hi @seenai ,
The time intelligence function PREVIOUSYEAR() requires a continous date column, I would suggest you creating another calendar table with the CALENDARAUTO() function.
Best Regards,
Teige
The scope of this column function is the current row, you probably will not get a return value from current row.
Instead, you can create a variable that calculates the needed value as follows (this is an experiment!)
LY =
var theCalculation = CALCULATE(SUM(KPI_MfgExp[Actual]),PREVIOUSYEAR(KPI_MfgExp[Month]))
return LY
User | Count |
---|---|
86 | |
82 | |
68 | |
67 | |
55 |
User | Count |
---|---|
123 | |
100 | |
90 | |
83 | |
66 |