Forum Discussion

tryan's avatar
tryan
Frequent Visitor
9 years ago
Solved

DAX if statement syntax error

I am trying to write a simple if statement in power pivot using DAX.  I wrote many if statement that return either a 1 or a 0 depending on whether or not the logical statement is true or false.  Howe...
Need Help
  • Phil_Seamark's avatar
    Phil_Seamark
    9 years ago

    Is this a calculated column or calculated measure?

     

    If it is a calculated column, what is the datatype set to?

Phil_Seamark's avatar
Phil_Seamark
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

Is this a calculated column or calculated measure?

 

If it is a calculated column, what is the datatype set to?

tryan's avatar
tryan
Frequent Visitor
9 years ago

Phil,

 

Thanks for your quick reply.  That was the issue.  I was adding a calculated column to a dataset, and it was defaulting to a number format for some reason when it needed to be text.  When I reopened the file this morning, for some reason I didn't need to even reformat the calculated column.  When I wrote the formula it automatically sensed the column format needed to be text.  But here is are the steps for reformatting a column if anyone else views this thread:

 

https://support.office.com/en-us/article/Set-the-data-type-of-a-column-in-Power-Pivot-e62c582e-824f-439a-8437-680534100e11