Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Monthly Calculations

Hi everyone, sorry if I am posting much lately ðŸ˜€   For a use case I would like to have some cards with expenses/revenues for specific months in the past. Depending on the data-refresh time I would...
Need Help
  • Icey's avatar
    Icey
    6 years ago

    Hi Anonymous ,

     

    As far as I understand, try to do this:

     

    1. I make some changes to your Fact Table.

    2. I create a DimDate table, not using yours.

    DimDate = CALENDAR ( MIN ( FactSilverfin[Monthname] ), TODAY () )

     

    3. Create relationship.

     

    4. Create your measures and put them in Cards.

    For more details, please check the attached PBIX file. 

     

    If I understand you incorrectly, please let me know.

     

     

    Best Regards,

    Icey

     

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

     

Icey's avatar
Icey
Community Support
6 years ago

Hi Anonymous ,

 

Are there any other questions? If not, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

 

 

Best Regards,

Icey

 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Icey  No thanks, I used a calander table like u said and that seemed to solve the problem. Which is really weird because my other time calculations work fine with my old Dimdate table but yeah. 

 

For the bonus question (compare results to previous year) I used PARALLELPERIOD

 

ExpensesSecondLastMonthLastYear = CALCULATE([ExpensesSecondLastMonth];PARALLELPERIOD(DimDateTest[Date];-12;MONTH))