Forum Discussion

Zaynah16's avatar
Zaynah16
Icon for Helper I rankHelper I
4 years ago

LAG FUNCTION DAX

Hi Guys,    Please can someone help with a lag function.    Calculation needed :  Working Platform Conversion =  Buying Platform(This Year BP- LY BP )/Last year WP   Required output in BI  S...
ValtteriN's avatar
ValtteriN
Icon for Community Champion rankCommunity Champion
4 years ago

Hi,

Unfortunately I am not able to provide the pbix file. 

Zaynah16's avatar
Zaynah16
Icon for Helper I rankHelper I
4 years ago

My Column seems to not be working and returned blank values ? ValtteriN 

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi Zaynah16 ,

    Could you please share some sample data (exclude sensitive data) and your expected result with calculation logic and special examples in order to make troubleshooting and provide you a suitable solution? It is better if you can provide a simplified pbix file. Thank you.

    In addition, it seems that you are trying to get the difference between the current year and the previous year and then do the rest of the calculations based on your description. If that is the case, you can refer to the following blog to implement it.

    How to compare Last year and Current Year sales in Power BI?

    CREATING A POWER BI CHART COMPARING EACH YEAR VS PREVIOUS YEAR

    Best Regards