Forum Discussion
Monthly Calculations
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.
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.
Hi Icey thanks for your reply, I still don't understand why it works in your file, and why it won't workin my original file.
Step 1: What exactly did you do here?
Step 2: I have exactly the same column in my original DimDate table
Step 3: I have the same relationship
Step 4: Put my measures in cards an get empty values back
thanks
Hi Anonymous ,
Step 1: This month is March. But in the sample data you provided, no data for the last three months. So, the results will show as blank. After I changed the date, results show.
I have one question: how do you define the current month? Is it the month in reality or the month you selected?
Best Regards,
Icey
Icey aah okay, in my real dataset I have data up to january 2020, so my cards ExpensesSecondLastMonth and ExpensesThirdLastMonth should give me some numbers right?
Current month would indeed be the month in reality, so the cards ExpensesCurrentMonth and ExpensesLastMonth should be empty.
--> could be that my measures could be better,I dunno. Pretty new to (Power) BI.
Cheers
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