Forum Discussion
Conditonal column in tabel view.
Hi all,
I am new to powerbi and I am sorry if my powerbi lingo isn't correct.
We have recently discovered a problem with our data, during the summertime period all the data that has been put in comes in as the day before. I have gotten help to fix the dates so all my visuals are correct when showing statistics based on months.
However, this fix is only available in Tabel view. I need to make a column based on the difference of two dates (both having to be adjusted because of sumertime) where I can see if it was reported in 1 day, within 3 days, 7 days, 14 days or more. I know you can use condtional column in power quiery, but as I only have the date columns in Tabel view I'm not able to do that. Is there a way to make this calculation in powerbi so I can see how many days it took to report?
2 Replies
Hello Vala ,
can you show a sample data about the case you're telling so we could be able to assist you more.
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 💡Hi Idrissshatila ,
yes of course. Here's a snippet of the data I have with the orignal date and the fixed version.
