Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Data connectivity - Total Yearly Value

Hello Felows, I've issue with data connectivity and I hope you will help me to resolve it. Basically I've two data sets. First data set shows Actual Yearly QTY and second data set shows Target Ye...
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

Anonymous , Refer if my two blog on yearly target if the can help 

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

 

powerbi 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

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    amitchandak , unfortunately your blog does not help or provide resolution to my issue. 
    As I mentioned above, I've two datasheets that I'm stuggling to connect. 
    I'm using slicer to visualize the Actual QTY and Target QTY for 2020,2021 & 2022 in the table. 
    The table only shows correct value for Target QTY but somehow summarizes Actual QTY: