Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi everyone 🙂
First steps with Power BI here.
I'm working on road accidents, trying to build a table to compare the number of accidents for every month of 2022 with the same month of 2021.
I work from a very simple table (Table_Accidents) that contains a line for every accident and elements on these accidents (date, place, type, etc.).
So I did the following :
I made a DAX formula to count the number of lines, which is my total number of accidents :
Nb_Accidents = COUNT(table_Accidents[#])
"#" being the name of the column where I just apply a different number to a new accident.
Then I wrote this formula :
Solved! Go to Solution.
Hi @CertainlyMe
SAMEPERIODLASTYEAR is a time intelligence function that requires a proper date table with unique and contiguous date values. Create a date table snd create a relationship between the date table snd your table then you can use 'Date'[Date] in SAMEPERIODLASTYEAR
Hi @CertainlyMe
SAMEPERIODLASTYEAR is a time intelligence function that requires a proper date table with unique and contiguous date values. Create a date table snd create a relationship between the date table snd your table then you can use 'Date'[Date] in SAMEPERIODLASTYEAR
Check out the July 2025 Power BI update to learn about new features.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
User | Count |
---|---|
23 | |
10 | |
10 | |
9 | |
7 |