How to implement DatesYTD logic in spotfire

[guntur chandrasekhar]

How to implement DatesYTD logic in spotfire

[Douglas Johnson]

If I understand correctly, you are referring to the DatesYTD function in Microsoft Excel that is discussed in the online Microsoft article at the following URL:

https://learn.microsoft.com/en-us/dax/datesytd-function-dax

.

If that is correct, please build a small, simple Spotfire analysis (DXP file), with non-proprietary data embedded or stored in it, that illustrates your particular DatesYTD use case.

.

Please be sure to include a column you have imported from MS Excel that shows the result you achieved when you used DatesYTD in Excel.

Please also provide the formula or expression you used in MS Excel when you calculated that column using DatesYTD.

.

A concrete, sharable example always helps make the discussion here more productive.

It will also help focus the discussion if you post the version of Spotfire you are using.

[guntur chandrasekhar]

I require this datesytd logic in the spotfire

[Douglas Johnson]

Yes, I understand that you are using DatesYTD in Excel, and you would like to know if there is a way to do the same task in Spotfire.

Spotfire does not have a DatesYTD function.

But if you post a small, simple Spotfire analysis (DXP file) here, with non-proprietary data embedded or stored in it, that illustrates your particular DatesYTD use case, we can see if there is a way to do that specific task using a Spotfire expression.

In your example DXP file, please be sure to include a column you have imported from MS Excel that shows the result you achieved when you used DatesYTD in Excel.

Please also post the formula or expression that you had used in MS Excel when you calculated that result column using DatesYTD.