The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
If i calculate 1st june then my logic will be count of (1st to 7th) result will show in 1st june ..similarly 2nd june count will be ( 2nd june to 8th june) as per above output table..
i need a measure for this..
Thanks !!
Solved! Go to Solution.
Hi @Anonymous ,
I suggest you to create a measure by this code.
Measure =
CALCULATE(COUNT('Table'[Value]),FILTER(ALLEXCEPT('Table','Table'[ID]),'Table'[Value]<>BLANK()&&'Table'[DT]>=MAX('Table'[DT])&&'Table'[DT]<=MAX('Table'[DT])+6))
Result is as below.
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@Anonymous Hello,
For above image 2nd table result should not be blank, it is counting running date wise.
as per dax if some value is not there againt date , it is showing blank instead of counting ...
Thank you so much buddy ...Its helps me a lot....
if anyone trying to this getting any confusion please drop a message here....
Hi @Anonymous ,
I suggest you to create a measure by this code.
Measure =
CALCULATE(COUNT('Table'[Value]),FILTER(ALLEXCEPT('Table','Table'[ID]),'Table'[Value]<>BLANK()&&'Table'[DT]>=MAX('Table'[DT])&&'Table'[DT]<=MAX('Table'[DT])+6))
Result is as below.
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.