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
v-easonf-msft's avatar
v-easonf-msft
Community Support
6 years ago

Hi , Anonymous 

Can you show me the relationship between your calendar table and fact table?

In addition, please pay attention to the data type and  summarization of your field "ReportDate".

 

Best Regards,
Community Support Team _ Eason

 

 

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