Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi All!
I need your help
I Created in my DB column in the dim date that is called "Date Button"
The column contains three categories
Yesterday
30 days back
90 days back
Now I try to put that column in the slicer that filters my date
The problem is the 30 days give me 29 days
and the 90 days bring me 60 days
I tried formulas and a calculated column but without success
I would appreciate your help
Attach the file
Solved! Go to Solution.
Hi All,
I found the solution
1. First open a new table
and insert that Dax code:
Hello @netanel ,
so this is calculated wrong from the db, because when I tried filtering the table from the data view to see the rows related to last 30 days it showed 29 as you can see in the screenshot.
And when i filtered it to show the last 90 days it only filtered 60 rows
so you should check the calculation of this column from the database calculation because power bi is reflecting it as it was calculated.
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Follow me on Linkedin
Vote for my Community Mobile App Idea 💡
Proud to be a Super User! | |
But that's the whole idea, think about it
In SQL I bring one column
Yesterday is one line
Last 30 Days can't register on yesterday
The last 90 Days cannot be registered on 30 days and yesterday
Now in Power BI, I am trying to calculate a measure
That 30 days back will bring me both yesterday and the 30 days
Beyond that, you have a separate column for each date as well
Last 30 Days whit 30 rows
Last 90 Days whit 90 rows
Hello @netanel ,
So i adjusted the last 30 days measure to the following:
And the last 90 days to the following
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Follow me on Linkedin
Vote for my Community Mobile App Idea 💡
Proud to be a Super User! | |
That doesn't answer my question...
I need one measure to insert in the slicer
And get 30 days for "Last 30 Days"
And 90 Days for "Last 90 Days"
and also Yesterday
Hi All,
I found the solution
1. First open a new table
and insert that Dax code: