Forum Discussion

rks408's avatar
rks408
New Member
1 year ago
Solved

Create YoY Measure without error A date column containing duplicate dates was specified in the call

I am a novice at PowerBI and I'm very confused with measures and dates at the moment so any guidance would help. I'm trying to create a few year over year charts/tables that are counting the number o...
Measures
yoy
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi rks408 

     

    Thank you very much Sahir_Maharaj for your prompt reply.

     

    Based on the screenshot information you provided, I made some adjustments to this solution:

     

     

    Create measures.

     

    ItemCount = COUNT('Count Table'[Title])

     

    ItemCount LY = 
CALCULATE(
    COUNT('Count Table'[Title]),
    FILTER(
        'Count Table',
        YEAR('Count Table'[Created On]) <= YEAR(TODAY()) - 1
    )
)

     

    Here is the result.

     

    Regards,

    Nono Chen

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Sahir_Maharaj's avatar
Sahir_Maharaj
Super User
1 year ago

Hello rks408, and thank you Anonymous for this excellent approach.

 

Building on the DAX by Nono Chen, can you please try this approach:

ItemCount LY = 
CALCULATE(
    COUNT('Count Table'[Title]),
    FILTER(
        ALL('Count Table'[Created On]),
        YEAR('Count Table'[Created On]) = YEAR(MAX('Count Table'[Created On])) - 1
    )
)

Hope this helps.

rks408's avatar
rks408
New Member
1 year ago

Hi Sahir, 

I am still having issues with the aggregated data. As you can see when I use just the date for Created On, it is calculating 208 for all of 2018 at the row level and when I use the year from the Created On date hierarchy it is blank. Is there perhaps a different way I should be formatting Created On? Once again I am limited as I cannot create a new table or columns.