Forum Discussion

franciscomacedo's avatar
franciscomacedo
New Member
4 years ago

A Line Graphic Question

Hey everyone,

 

I'm doing a measure to show the weeks in the actual month on my dashboard but, it's showing more weeks then I have.

 

Example: The last data I have, it's 16/11/2021. It's supposed to show 3 weeks in november, but it's showing 6 weeks (3 more that are not in my database.

 

This is the formula that i'm using

B. TOTAL DE CLIENTES (MÊS ATUAL) =

VAR MESATUAL=VALUE(FORMAT(MAX(BD_MONITORAMENTO[DT_FASE_PIPELINE]),"M"))

RETURN

CALCULATE([B. TOTAL DE CLIENTES ABORDADOS],(BD_MONITORAMENTO[MÊS (NÚMERO)]=MESATUAL))

 

If I change the expression in the calculate to 11, it show's the 3 weeks in november. But I want to do it automatically 

Tips and Tricks

3 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    4 years ago

    Most likely you are missing the year filter. Please provide sanitized sample data that fully covers your issue. Paste the data into a table in your post or use one of the file services. Please show the expected outcome.

  • v-kkf-msft's avatar
    v-kkf-msft
    Community Support
    4 years ago

    Hi franciscomacedo ,

     

    I used the following sample data and and model.

     

       

     

    Then created the measure, which in my test returned only 3 weeks of data in November. Could you please share your example data and model?

     

    B. TOTAL DE CLIENTES (MÊS ATUAL) = 
VAR MESATUAL =
    MONTH ( MAX ( BD_MONITORAMENTO[DT_FASE_PIPELINE] ) )
RETURN
    CALCULATE (
        [B. TOTAL DE CLIENTES ABORDADOS],
        ( BD_MONITORAMENTO[MÊS (NÚMERO)] = MESATUAL )
    )

     

    Best Regards,
    Winniz

  • v-kkf-msft's avatar
    v-kkf-msft
    Community Support
    4 years ago

    Hi franciscomacedo ,

     

    Has your problem been solved? If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.

     

    Best Regards,
    Winniz