Forum Discussion

Stefkus's avatar
Stefkus
Frequent Visitor
9 years ago
Solved

Text format changes after import from SSAS tabular

Hi all,   In my tabular model I have the field Duration2, it's calculated with DAX. The field is formatted as Text and displays the value of the field Duration (which is in whole number) in format ...
Need Help
  • v-ljerr-msft's avatar
    v-ljerr-msft
    9 years ago

    Hi Stefkus,

     

    Have you noticed that the value of "Duration" column shown on the report is smaller(276 and 25, instead of 16529 and 1452)?

     

     

    For Duration 276, the Duration2 should be "00:04:36", the value is right. So the format of Duration2 doesn't change, it works all fine on both side. I think it's why the value of Duration column that become smaller when shown on the report you should figure out. Maybe you have applied some page/report level filter? Or you're not showing columns from the same table on the Table visual? And that should be easier to check.:smileyhappy:

     

    Regards

v-ljerr-msft's avatar
v-ljerr-msft
Microsoft Employee
9 years ago

Hi Stefkus,

 

Have you noticed that the value of "Duration" column shown on the report is smaller(276 and 25, instead of 16529 and 1452)?

 

 

For Duration 276, the Duration2 should be "00:04:36", the value is right. So the format of Duration2 doesn't change, it works all fine on both side. I think it's why the value of Duration column that become smaller when shown on the report you should figure out. Maybe you have applied some page/report level filter? Or you're not showing columns from the same table on the Table visual? And that should be easier to check.:smileyhappy:

 

Regards

  • Stefkus's avatar
    Stefkus
    Frequent Visitor
    9 years ago

    Thanks a lot, I think I was a bit sleepy at the time... :)

     

    You pointed me in the right direction. It was working all along but SSAS exported to another databasetable than I was aware of...

     

    regards,

    Stefan