Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hello,
Context:
I have a table named "Projects" with two columns: Project and Project_Date.
On the report, there is a table and a slider linked to a What-if parameter (Days_Th) which is a number between 1 and 30.
Objective:
I want to display all the lines of the table with Project_Date in [today, today + Days_Th] (days_th is a number defined by a what-if parameter).
What I have tried:
Creating a calculated column with a IF statement and filter the table with this column.
Solved! Go to Solution.
@Anonymous , You can not use the slicer value in a calculated column , you need to create a measure
exameple
countx(Projects, IF(AND(Projects[Project_Date] >= NOW(), Projects[Project_Date] <= NOW() + Days_Th[Valeur Days_Th]), 1, 0) )
Thank you for the tip. The COUNTX didn't work so I replaced it with a SUMX which seems to work!
Thank you very much 🙂
@Anonymous , You can not use the slicer value in a calculated column , you need to create a measure
exameple
countx(Projects, IF(AND(Projects[Project_Date] >= NOW(), Projects[Project_Date] <= NOW() + Days_Th[Valeur Days_Th]), 1, 0) )
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
73 | |
72 | |
38 | |
31 | |
26 |