Forum Discussion

Prima_'s avatar
Prima_
Icon for Resolver I rankResolver I
4 years ago

Detect a Column value change and increment another value

Hi,   Whenever the version is changed in Table B, the Upgraded_sites in Table A should be incremented. Week is a filter. In this case, Week 2, 3 and 4 are selected. Table B shows, two sites in Aust...
Need Help
Tutorial Requests
Prima_'s avatar
Prima_
Icon for Resolver I rankResolver I
4 years ago

Hi Icey,

 

Getting the conversion error. Week field is Whole Number and the other fields are text.

 

Thanks.

Icey's avatar
Icey
Icon for Community Support rankCommunity Support
4 years ago

Hi Prima_ ,

 

Could you check the Data type of each column again. I can only reproduce this issue when I change the data type of “Week” column from "Whole Number" to "Text".

 

 

Best Regards,

Icey

  • Prima_'s avatar
    Prima_
    Icon for Resolver I rankResolver I
    4 years ago

    Week field is whole number. 

     

    Thanks.

     

    • Prima_'s avatar
      Prima_
      Icon for Resolver I rankResolver I
      4 years ago

       

      • Icey's avatar
        Icey
        Icon for Community Support rankCommunity Support
        4 years ago

        Hi Prima_ ,

         

        If you could create a sample file with the same issue, please share me. 

         

        If you could not due to data security issues, please check each variable returned in the expression and check the data type.

         

        Reference: How to provide sample data in the Power BI Forum

         

         

        Best Regards,

        Icey