Jump to content
We've recently updated our Privacy Statement, available here. ×

How to implement DatesYTD logic in spotfire


guntur chandrasekhar

Recommended Posts

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.

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...