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.

rks408's avatar
rks408
New Member
1 year ago

 

Hello, thank you for your reply. This got rid of my error message but the data isn't populating in the table correctly. 

For reference:

The year property of the date hierarchy for Created On is being used. The dummy data you provided reflects what my data looks like. When I had Created On as just the date and not the hierarchy, 208 did populate for 2018's ReportCountLY but when the data is aggregated it is not working. Thank you 

 

 

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.