Dear Jarrett
I really appreciate your response. I replicated the measure in the main data table. Iam getting a blank column.
I therefore researched a bit more and introduced two columns in the Date table for workdate and workday. However, iam not able to solve the problem.
I therefore request your help to review the Powerbi file and help me replicate the working in the excel file ‘data’ for col value 1 and value 2.
The objective of introducing work day was to replicate the concepts of “Weekday” in this working.
: Ref: https://www.youtube.com/watch?v=2umfdZElvDU
If i manage to add a date field using the workday column then i can use concepts such as PreviousDay etc. However, iam not able to do this and need help
Value 2 : replicates the EMA calculation done in the below link
I would really appreciate your help
Regards
JTest1.zip (1.6 MB)