Forum Discussion

Qtzalcoatl's avatar
Qtzalcoatl
New Member
7 years ago
Solved

MOM Calc do not work with global date filter

Hi,

 

I have a financial Dashboard which I am filtering on reporting month through a slicer. I have some Month on Month figures which are working fine when the reporting date filter comes directly from the same data source. I am adding other operational statistics from other data sources to the Dashboard and making a relationship between all the sources' 'Reporting Date' with a new 'Date Table'. Now I can filter all data sources on the Dashboards through the common Date Table. However, the MOM figures now turn blank....

 

I would guess that the my previous month formula is no longer able to look at previous month:

Revenue LM = CALCULATE([Revenue];PREVIOUSMONTH(CBS[ReportPeriod]))

 

Anyone knows a solutions to having MOM figures and visualizations from other data sources on the same Dashboard with a common date fitler for the dashboard visualizations?

 

Any feedback appreciated :)

 

Paal

 

 

Need Help
  • v-juanli-msft's avatar
    v-juanli-msft
    7 years ago

    Hi Qtzalcoatl 

    How do you create relationships between the the table( where [Revenue] is) and date table ("CBS" this is a date table?) ?

    Please create a relationship based on "date" columns for two tables.

     

    Which visual do you add the "year","month" columns and measure [Revenue LM] in?

    Could you share a screenshot to show which fields to add in the visual?

     

    You could read more about " PREVIOUSMONTH" function and how to use it.

    https://community.powerbi.com/t5/Desktop/PREVIOUSMONTH/td-p/13307

     

    Best Regards
    Maggie

     

    Community Support Team _ Maggie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

2 Replies

  • v-juanli-msft's avatar
    v-juanli-msft
    Icon for Community Support rankCommunity Support
    7 years ago

    Hi Qtzalcoatl 

    How do you create relationships between the the table( where [Revenue] is) and date table ("CBS" this is a date table?) ?

    Please create a relationship based on "date" columns for two tables.

     

    Which visual do you add the "year","month" columns and measure [Revenue LM] in?

    Could you share a screenshot to show which fields to add in the visual?

     

    You could read more about " PREVIOUSMONTH" function and how to use it.

    https://community.powerbi.com/t5/Desktop/PREVIOUSMONTH/td-p/13307

     

    Best Regards
    Maggie

     

    Community Support Team _ Maggie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • Qtzalcoatl's avatar
      Qtzalcoatl
      New Member
      7 years ago

      Thanks Maggie!

       

      I changed reference in PREVIOUSMONTH to the common Date table instead of the Date column in my revenue table. That solved it!

       

       

      Thanks again :)

      Paal