Forum Discussion

ayush's avatar
ayush
Frequent Visitor
8 years ago

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

  • 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