Forum Discussion
Calculated column based on measure or slicer selection?
Hi all,
I have created two date measures one with start of date and one for the end of the date (i am selecting the date from date slider). I want to create a calculated column in my backed whose value should change based on my measures or slicer selection.
Example. If my start date is 1 Jan 2018 and end date is 30 Jan 2018, I want values in calculated column "Test" for that period (1 Jan - 30 Jan 2018) and for rest of the dates/period 0, and when I change my selection from 1 Feb to 28 Feb 2018, Values should refresh automatically in the backend (Now "Test" should come from 1Feb - 28 Feb 2018 and 0 for rest of the period)
Thanks in Advance.
1 Reply
- JosefPrakljacicSolution Sage
Hi,
what you have in mind will unfortunately not be possible.
Calculated columns are generated at processing time. Measures are calculated at runtime. This means that when your dataset/cube is loaded, the value of the calculated column will not change.Please don't forget to give a 👍 and accept the post as solution. (If it helped 😅)
Have a nice day!
BR,
Josef
Graz - Austria