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 All,
Please Note: I have created a calendar table with Date, Month, Year, Week, Etc.
What I needto do is Adapt this DAX formula to include the ability to Set the Time period I want it to Calculate.
The formula below Calculates Volumes by a Set criteria, in this case the number of time a Client appears in a Feed list.
However it calculates this by all the data in the main table which is a 3 month feed.
How do I adjust this so It will calculate the Number of time the Client appears but by a set time period I can control, eg a 1 Week, 2 Weeks, 1 Month Etc rather than the entire 3 month period.
Hi @Enrico501 ,
Cool ji, Can please try the bewlow formula for as per understand.
if u want the client how many have been repeated right?.
Step 1 :
take a new column using concatenate
Measure1 =concatenate ( Client name , Month)
step 2 :
=countrows(table name, filter(table name, earlier (Measure1 = measure1))),
If i meaniful you , please review kudo me :),
Regards,
Gokul.
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 |
---|---|
65 | |
64 | |
56 | |
39 | |
27 |
User | Count |
---|---|
85 | |
59 | |
45 | |
43 | |
38 |