topic Selected Period VS previous Period in DAX Commands and Tips

Selected Period VS previous Period

Anonymous — Thu, 30 Jul 2020 23:44:29 GMT

Hi all,

I need some help on below question. I have a table which contains different comments for different weeks, we do not necessarily have comment each week. However, there is ID for each week that we put comment there, like what you can see in below data. I want to have a slicer to select a date and then in another table we see the comments for both selected period and previous one. Thanks in advance.
Raha

Date	StatusComments	ID
5/04/2020	com1	6
26/04/2020	com2	7
10/05/2020	com3	8
7/06/2020	come4	9
12/07/2020	com5	10

Re: Selected Period VS previous Period

Anonymous — Fri, 31 Jul 2020 01:45:47 GMT

Can anyone help me?please?

Re: Selected Period VS previous Period

amitchandak — Fri, 31 Jul 2020 02:28:08 GMT

Anonymous , for WOW or any custom period you can so it using RANK.

Power BI — WTD Questions— Time Intelligence 4–5
https://medium.com/@amitchandak.1978/power-bi-wtd-questions-time-intelligence-4-5-98c30fab69d3
https://community.powerbi.com/t5/Community-Blog/Week-Is-Not-So-Weak-WTD-Last-WTD-and-This-Week-vs-Last-Week/ba-p/1051123

Make sure you have a separate date or period table

Normal period

Power BI — YTD Questions — Time Intelligence 1–5
https://medium.com/@amitchandak.1978/power-bi-ytd-questions-time-intelligence-1-5-e3174b39f38a
Power BI — QTD Questions — Time Intelligence 2–5
https://medium.com/@amitchandak.1978/power-bi-qtd-questions-time-intelligence-2-5-d842063da839
Power BI — MTD Questions — Time Intelligence 3–5
https://medium.com/@amitchandak.1978/power-bi-mtd-questions-time-intelligence-3-5-64b0b4a4090e

To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :
https://radacad.com/creating-calendar-table-in-power-bi-using-dax-functions
https://www.archerpoint.com/blog/Posts/creating-date-table-power-bi
https://www.sqlbi.com/articles/creating-a-simple-date-table-in-dax/

See if my webinar on Time Intelligence can help: https://community.powerbi.com/t5/Webinars-and-Video-Gallery/PowerBI-Time-Intelligence-Calendar-WTD-YTD-LYTD-Week-Over-Week/m-p/1051626#M184

Appreciate your Kudos.

Re: Selected Period VS previous Period

lbendlin — Fri, 31 Jul 2020 02:42:16 GMT

First step: create a calculated table and feed it into the slicer.

Table 2 = values(Comments[Date])

Second step: create a measure

Visible := var s = SELECTEDVALUE('Table 2'[Date]) var c = max(Comments[ID]) var t = CALCULATE(max(Comments[ID]),all(Comments),Comments[Date]=s) return c=t || c=t-1

Third step: use the measure to control the visibility of the comments in your table visual

Re: Selected Period VS previous Period

Anonymous — Fri, 31 Jul 2020 03:46:48 GMT

Thanks so much, that was what I needed. But I can not just filter on true value. Not sure how I should do it. It is showing both true and false values.

Re: Selected Period VS previous Period

lbendlin — Fri, 31 Jul 2020 04:07:13 GMT

under "Filters in this visual" set the "Visible" filter to "True"