Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi,
I am trying to find out the previous day Service Requests(Based on date user chooses) and it seems like I am mising something.
My data looks like this. I have date in the same table.
My New Measure for Prior Day request is like this:
I am getting the following error:
I even tried with 'LAST DATE' & NEW COLUMN given in below post but still did not work.
https://community.powerbi.com/t5/Desktop/Previousday-function-problem/m-p/1100277#M509432
Can somebody help me with this?
Regards
PPRASAD2
Solved! Go to Solution.
Hi , @pprasad2
I can reproduce your problem. For more details ,please check the sample file.
You are using time intelligence functions PREVIOUSDAY which is suggest to use with a separate date table/dimension.
There are duplicate values(Date Range) in your table ( same date in multiple rows ).
It is suggest to create a calendar table with unique and continuous dates that cover all periods of your fact table.
Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi , @pprasad2
Could you please tell me whether your problem has been solved?
If yes, you could accept the helpful answer as solution. You also could share your own solution here. For now, there is no content of description in the thread. If you still need help, please share more details to us.
Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi , @pprasad2
I can reproduce your problem. For more details ,please check the sample file.
You are using time intelligence functions PREVIOUSDAY which is suggest to use with a separate date table/dimension.
There are duplicate values(Date Range) in your table ( same date in multiple rows ).
It is suggest to create a calendar table with unique and continuous dates that cover all periods of your fact table.
Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @v-easonf-msft, can you provide the sample file again? I cannot access the sample file. Thank you
See if my Time Intelligence the Hard Way provides a different way of accomplishing what you are going for.
https://community.powerbi.com/t5/Quick-Measures-Gallery/Time-Intelligence-quot-The-Hard-Way-quot-TIT...
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
Check out the May 2024 Power BI update to learn about new features.
User | Count |
---|---|
91 | |
85 | |
65 | |
62 | |
58 |
User | Count |
---|---|
150 | |
113 | |
95 | |
80 | |
72 |