Forum Discussion

Helper IV

6 years ago

Solved

Calculation with different data types

Hi I have the below table, I have put what data type they are above each header. What I want to achieve is the outcome column, the outcomes are below. I am struggling with the different date form...

Need Help

v-lili6-msft
6 years ago
hi, WJ876400

The column is going in the values of the matrix table because of the way it is contsructed if that is causing an issue

Column in matrix value will be aggregated, this should be the reason for it.

And this formula is used for a calculated column, so it will work in data table, You may adjust the formula as a measure.

https://www.sqlbi.com/articles/calculated-columns-and-measures-in-dax/

If you still have problem, please share your sample pbix file for us have a test.

Regards,

Lin

WJ876400

Helper IV

6 years ago

Hi v-lili6-msft

thanks for the help. I have added in a column and put in the formula but it doesn't seem to work for certain fields. It is not putting to be scheduled where the last review is blank and the next review is to be scheduled. It is also not using the next review date when the next review is 30 days greater than the last review. The column is going in the values of the matrix table because of the way it is contsructed if that is causing an issue?

thanks