Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers!
Enter the sweepstakes now!Preparing for a certification exam? Ask exam experts all your questions on May 15th. Register now.
Hi ,
I need to create a dynamic previous month showing data in power bi
I have date column in Fact table as "date"
I also have views col as "views" in Fact table
I have type name col in Dim table
If I select particular month from date filter it must show count(views) for previous month of selected month for the Type= News, Reminders and Good to know in my power bi
For example if I select Sep-2022 it must show Aug - 2022 count of views for Type News, Reminders and Good to know
It must show count for News , Reminders and Good to Know separately
Type | Prev Month Count |
News | 500 |
Reminders | 267 |
Good to know | 900 |
Like above table it must show
I have a relationship between dim table and fact table with ID
Please help
Thanks in advance!!!
Hello @Anonymous,
Use the following DAX formula to calculate the count of views for the previous month:
Prev Month Count =
VAR SelectedMonth = SELECTEDVALUE('Fact table'[date])
VAR PreviousMonth = EDATE(SelectedMonth, -1)
RETURN
CALCULATE(
COUNT('Fact table'[views]),
'Fact table'[date] = PreviousMonth,
'Dim table'[Type] IN {"News", "Reminders", "Good to know"}
)
Let me know if you might need further assistance.
Hello @Anonymous,
Use the following DAX formula to calculate the count of views for the previous month:
Prev Month Count =
VAR SelectedMonth = SELECTEDVALUE('Fact table'[date])
VAR PreviousMonth = EDATE(SelectedMonth, -1)
RETURN
CALCULATE(
COUNT('Fact table'[views]),
'Fact table'[date] = PreviousMonth,
'Dim table'[Type] IN {"News", "Reminders", "Good to know"}
)
Let me know if you might need further assistance.
Check out the April 2025 Power BI update to learn about new features.
Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.
User | Count |
---|---|
78 | |
76 | |
70 | |
49 | |
42 |
User | Count |
---|---|
56 | |
47 | |
33 | |
32 | |
28 |