Intellipaat Back

Explore Courses Blog Tutorials Interview Questions
0 votes
2 views
in BI by (11.1k points)

I have tried this but I am getting a different measure

Last7days = 
CALCULATE(
        DISTINCTCOUNT('application_overview'[posting_number]),
        FILTER(ALL('application_overview'), 'application_overview'[app_submitted_date] >= TODAY()-700)
)

Here, The problem is I can't able to set The Textbox

1 Answer

0 votes
by (22.5k points)
edited by

Try using this measure

Last7daysPostings = 
var res = CALCULATE(
        DISTINCTCOUNT('application_overview'[posting_id]),
        FILTER(ALL('application_overview'), 'application_overview'[app_submitted_date] >= TODAY()-7)
        )
return res&""

Go for this in-depth job-oriented Power BI training online now!

Related questions

0 votes
1 answer
asked Mar 2, 2021 in BI by Chris (11.1k points)
0 votes
1 answer
0 votes
1 answer
asked Mar 28, 2021 in BI by Chris (11.1k points)

31k questions

32.8k answers

501 comments

693 users

Browse Categories

...