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.

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi rks408 

 

 

Here's some dummy data

 

 

Try this:

 

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

 

Here is the result.

 

If you're still having problems, provide some dummy data and the desired outcome. It is best presented in the form of a table.

 

Regards,

Nono Chen

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