Forum Discussion

tashaq's avatar
tashaq
Regular Visitor
5 years ago
Solved

YoY Calculation for non cumulative data

Hi,   First time poster so apologies if this is in the wrong place.   I have annual data which is defined at source as academic years (15/16, 16/17 etc) and Ive added a lookup to convert these to...
Need Help
  • Kumail's avatar
    Kumail
    5 years ago

    tashaq 

     

    -You needed to create the relationship in the model between Year Lookup table and DateTable.

     

    Regards

    Kumail Raza

    Did this help? Kudos are appreciated.

    Consider Accept it as the solution to help the other members find it more quickly.

amitchandak's avatar
amitchandak
Super User
5 years ago

tashaq , Need sample data. But I think My blog on similar topic can help

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

 

Distributing/Allocating the Yearly Target(Convert to Daily Target): Measure ( Daily/YTD): Magic of CLOSINGBALANCEYEAR With TOTALYTD/DATESYTD: https://community.powerbi.com/t5/Community-Blog/Power-BI-Distributing-Allocating-the-Yearly-Target-Convert-to/ba-p/1476400

 

 

Distributing/Allocating the Yearly Target(Convert to Daily Target): https://community.powerbi.com/t5/Community-Blog/Distributing-Allocating-the-Yearly-Target-Convert-to-Daily/ba-p/1463290

  • tashaq's avatar
    tashaq
    Regular Visitor
    5 years ago

    Still struggling - can anyone help with this please or have any thoughts?