• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

INFO.FORMATSTRINGDEFINITIONS() ???

jutu

Member
When I try to add a column to extract the month name to create a date hierarchy, I type for the FORMAT function but only the below function comes up if you can help please. I need to create a date hierarchy and it's ok extract it from transform for the year of the date but if I do extract the month name it asks me to convert all the tables into Import query which I don't want. Thanks

INFO.FORMATSTRINGDEFINITIONS()

This function, whatever it is, it seems to take extremely long time to run. Now running for over one hour so far in DirectQuery mode and still on. Not having a way to stop it from running and neither having the faintest idea how long is it going to take (wouldn't it be helpful if ms guys added some sort of an stopper?) I have to kill it from Task Manager so I really don't know what it brings
 
This is delaying me a lot and I only need the month name now since I already have the year. If I create a measure for the month name, can it be added in the year table to be included in the hierarchy?
 
Both DAX and calc columns both have FORMAT function indeed but I found a way around it but still puzzled about the INFO.FORMATSTRINGDEFINITIONS() function that it brought when called up the FORMAT function. The FORMAT function wasn't there at the time at all but I found a way in any case so it's not an issue. Thank you so much
 
Back
Top