Forum Discussion

StefanoP's avatar
StefanoP
Regular Visitor
3 years ago

Table with computed values that populate a measure table based on 2 date filters

Hello there, I'm a fresh approacher to this world of PowerBi and its related products and functions. Even if I understand ( more or less ) how it works and what to do, I'm stuck in "how to do it". ...
StefanoP's avatar
StefanoP
Regular Visitor
3 years ago

I got this counter intuitive results :

For the whole year selected for 2022 i got only 2 months drawing, instead for 2023 a whole year.

See here

 

 

  • tamerj1's avatar
    tamerj1
    Icon for Community Champion rankCommunity Champion
    3 years ago

    StefanoP 
    There is nothing in the code that filters only 2 months. To be honest I don't understand the example you have presented. In this case I would kindly request you to provide sample data of all related tables along with the relational data model details and relationships. Also the DAX for the measure that you're trying to calculate it's 3 months moving average. You may use dummy data but please try not to over simplify. 

  • StefanoP's avatar
    StefanoP
    Regular Visitor
    3 years ago

    Hello everyone, I fixed it by changing slicer settings.

    I'll update you if there will be something wrong.

    Thanks for all your help and dedication.