Forum Discussion

DutchMark's avatar
DutchMark
Icon for Helper III rankHelper III
1 year ago
Solved

Comparing last 12 months to previous 12 months (partial problem)

I compare the last 12 months with the previous 12 months.    I use 2 measurments: Revenue this year PM = SUM(KPI_EOL_sync_financial_transactionlines[Revenue]) Revenue LY PM = CALCULATE([Revenu...
Need Help
Tips and Tricks
  • v-kpoloju-msft's avatar
    v-kpoloju-msft
    1 year ago

    Hi DutchMark,

    We sincerely apologize for the inconvenience caused.

    As the issue is still not yet resolved, we kindly request you to raise an issue at Issues - Microsoft Fabric Community for investigation.
    Otherwise raise a Microsoft support ticket using the link provided below. They will be able to provide specific insights related to your account and potential resolutions.
    Microsoft Fabric Support and Status | Microsoft Fabric

    If you find our response helpful, kindly mark it as the accepted solution and provide kudos. This will assist other community members facing similar queries.

    Thank you.

DutchMark's avatar
DutchMark
Icon for Helper III rankHelper III
1 year ago

Everyone seems to read past what I'm asking and read past what I'm looking for.
- The filters need to be in the formula
- If I hover over Jan-25, the previous year needs to show in the LABEL Jan-24 and this year Jan-25
- Don't forgot the Matrix in the bottom. This is what it's all about. Because I need to be able to select both Jan-24 and Jan-25 seperately to see them next to each other. I don't see that now!