Selected Period VS previous Period

[Anonymous]

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

[lbendlin]

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

[Anonymous]

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.

[lbendlin]

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

[amitchandak]

@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.

[Anonymous]

Can anyone help me?please?