Forum Discussion
PREVIOUSMONTH Query
As you described, you want to achieve the same function as timestamp, which will not be possible in power bi. You can also understand the reason when you use power bi. It is a data display tool and does not provide data snapshot function. Since your status may be updated at any time, but the calculation logic of DAX is to filter out the data that meets your filter in the data you import, and then perform an aggregation.
So, if you want to achieve the timestamp function like Oracle database, then you can manually record it in excel in the monthly email subscription you mentioned. The report provides a "month-end" snapshot of our transaction volume and total at 2359 o'clock on the last day of each month.hackcrr
If I have answered your question, please mark my reply as solution and kudos to this post, thank you!
Hi ArchStanton
Can you please share a pbix or some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to coding formula.
How to Get Your Question Answered Quickly
Hi,
Thanks for your reply.
I've had a possible solution from a SuperUser that produces a result other than BLANK for the first time so we may be getting somewhere at last.
Can you have a look at my response to his solution and see if this is at all possible please?
Unfortunately I cannot share a pbix file for sommercial sensitivity reasons, the data model is huge and very complex so even producing a dummy file would take some time. If you think the other response is invalid and think its worthwhile, I'll try and create a dummy pbix file when I get some time.
Thanks,
Hi ArchStanton
Hi, I apologize, but in most cases, I really can't fully understand the request until I 'touch' the data myself. If the person who started working on it doesn't assist, I'll try to help once you attach the file.