Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Calculated field value from max selected date

Hi Team,   I have condition to categorize the aging of Invoice if (invoice[Aging]>120,"> 120", if (invoice[Aging]>90 && invoice[Aging]<=120, "90-120", if (invoice[Aging]>60 && invoice[Aging]<...
Need Help
v-easonf-msft's avatar
v-easonf-msft
Community Support
6 years ago

Hi , Anonymous 

Once the calculated column is created, its results in the table  will not be affected  no matter how you change the slicer value .

So all new data fields  that need to be affected by the slicer should be created with measure rather than calculated column. 

 

In fact,  I think  you already got the results you want. The two correct visual on the upper left and lower right that you have kept is exactly what you want.

 

 

 

If I misunderstand,please feel free to let me know.

 

Best Regards,
Community Support Team _ Eason

 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

 Hi v-easonf-msft 

 

Many thanks for your response

 

For my condition m Aging calculated measures is the correct one (in red colour) since the aging calculated base on the latest selected date, you can see the different result between c Aging (today) and m Aging (lates selected date).

 

The problem is when m Aging Cat put in Bar Chart only shows one bar (>120 ). I don't know why the field m Aging Cat can't put in the axis of the bar chart. 

 

Regards,

Supriatna