Forum Discussion

bd_8_bc's avatar
bd_8_bc
New Member
4 years ago
Solved

Power BI Functions

Hi  Relatively new to using Power BI and just a bit stuck on something.   I have my data table and the table I'am building in Power BI as below:   Data Table Statement Month    Cust ID.      Ch...
  • DataInsights's avatar
    DataInsights
    4 years ago

    bd_8_bc,

     

    I entered your sample data and got the desired outcome. If you can share your pbix via one of the file services like OneDrive, I'll take a look.

     

     

bd_8_bc's avatar
bd_8_bc
New Member
4 years ago

Hi and thanks for taking the time to respond.

 

It does work but I may not have been entirely clear with my question. It looks to the latest statement date however I did not mention that the customer ID may not appear in all months so it may not always be the latest months statement if the customer did not appear and could be May's statement date where the latest rate appears for the customer.

 

The measure does pick up the correct rates but only for customers who appear within the latest statement date but not all customers appear every month, so the measure would need to identify the latest statement month the cust ID appears in and then return the rate from there? Thanks  

v-easonf-msft's avatar
v-easonf-msft
Community Support
4 years ago

Hi, bd_8_bc 

Can you retry DataInsights's approach?

On my side, the measure also works fine for different customers.

If your problem persists, please provide a sample file for further research.

 

Best Regards,
Community Support Team _ Eason