Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

switch using date ranges

I have a DATE table with the following columns Date (DATE format), (the following columns are all Whole Numbers) WeekNum, Month, Day, Year, Qtr, End Date (DATE format), SprintNumber (whole number) (...
Need Help
Geradav's avatar
Geradav
Icon for Responsive Resident rankResponsive Resident
5 years ago

Anonymous The FORMAT() function "Converts a value to text according to the specified format." (Source FORMAT function (DAX) - DAX | Microsoft Docs)

Therefore you would be comparing a number to a text data type.
Also, passing a number as text data type as argument to the VALUE() function is the same as just writing a literal number.

I agree with amitchandak  that if you have some sample PBIX that you can share with us, it would help in the process of helping you.

 

David

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Geradav Thanks for your help on this. Please see my most recent update. I have cleaned up the function. But I'm not getting the results for sprintnumber 2, or 4. 

 

Thanks in advance,

Jim