Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.