Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Calculated field value from max selected date

Hi Team,   I have condition to categorize the aging of Invoice if (invoice[Aging]>120,"> 120", if (invoice[Aging]>90 && invoice[Aging]<=120, "90-120", if (invoice[Aging]>60 && invoice[Aging]<...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi v-easonf-msft 

Thanks for you response and attached the table relations and you can download my pbix file https://1drv.ms/u/s!Aih1MRphMRei21KYxISSSRNhWlK9?e=3wtTzH 

 

 

RondaHill I had try with column but therresult of date always today but if I tried with measure the date result is latest of selected date but the issue in chart only shown I bar chart as picture how the differents

 

    

Anonymous's avatar
Anonymous
Not applicable
6 years ago

HI All,

 

I still did not get solution, any help appreciated.

 

Thanks & Regards,

  • v-easonf-msft's avatar
    v-easonf-msft
    Community Support
    6 years ago

    Hi , Anonymous 

    Sorry for late reply.

    It seems that you just need to  drag the measure "m_report date"  to "values",then you will get what you want ...

     

     

    Best Regards,
    Community Support Team _ Eason

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hi v-easonf-msft 

       

      I am agreed with you putting m_report date"  to "values" will be display correctly in table but still incorrect for aging calculation 

       

      Regards,

      supriatna

      • v-easonf-msft's avatar
        v-easonf-msft
        Community Support
        6 years ago

        Hi , Anonymous 

        Once the calculated column is created, its results in the table  will not be affected  no matter how you change the slicer value .

        So all new data fields  that need to be affected by the slicer should be created with measure rather than calculated column. 

         

        In fact,  I think  you already got the results you want. The two correct visual on the upper left and lower right that you have kept is exactly what you want.

         

         

         

        If I misunderstand,please feel free to let me know.

         

        Best Regards,
        Community Support Team _ Eason