topic Re: DAX to calculate the 7 days and last 14 days activity. in DAX Commands and Tips

DAX to calculate the 7 days and last 14 days activity.

sharpedogs — Mon, 03 Feb 2020 18:37:43 GMT

Hi,

I can do this easily using the the filter, but I really want to do it using DAX.

I've tried multiple "lastdate" variations but i'm not sure the syntext to move it back 7 or 14 days.

I have a the below table and i simply want a DAX that counts the number of devices that last log on in the past 7 days. i'll replacate that formular to then account for the last 14 days.

Device Name	Last Logon Date	Confidence Level
AAA	Jan 29	Medium
BBB	Jan 3	High
CC	April 21	Medium

Re: DAX to calculate the 7 days and last 14 days activity.

az38 — Mon, 03 Feb 2020 18:47:58 GMT

Hi sharpedogs

try

Measure = CALCULATE(COUNTROWS('Table');'Table'[Last Logon Date]>=today()-7)

do not hesitate to give a kudo to useful posts and mark solutions as solution

Re: DAX to calculate the 7 days and last 14 days activity.

sharpedogs — Mon, 03 Feb 2020 19:27:15 GMT

Tried.... and worked perfectly!!!

Re: DAX to calculate the 7 days and last 14 days activity.

sharpedogs — Mon, 03 Feb 2020 20:23:58 GMT

Hi, wondering if i can piggyback on my ask 🙂

Instead of the last 7 days... what if i now wanted a range say between 7 and 14 days? I'm not sure what i do with the TODAY () function so that is starts at 7 days?

Re: DAX to calculate the 7 days and last 14 days activity.

az38 — Mon, 03 Feb 2020 20:38:33 GMT

sharpedogs

try

Measure = CALCULATE(COUNTROWS('Table');'Table'[Last Logon Date]>=today()-14;'Table'[Last Logon Date]<=today()-7)

do not hesitate to give a kudo to useful posts and mark solutions as solution

Re: DAX to calculate the 7 days and last 14 days activity.

sharpedogs — Tue, 04 Feb 2020 00:44:40 GMT

Why is it so simply when you provide the answer....lol

Thanks

Re: DAX to calculate the 7 days and last 14 days activity.

az38 — Tue, 04 Feb 2020 14:46:40 GMT

sharpedogs

it's a practice question.

good luck and welcome to power bi! 🙂