Forum Discussion
IF statement with date
Hi All, Sorry for the basic question, i am new to PowerBI and slowly learning it! I have a table which has the following columns - Name (File Name), Extension (File type e.g .txt), size (siz...
Managed to get the Hot or Cold working, however it's creating duplicate rows for some reason?
The formula isn't creating extra rows. You have a merge that is causing that. I just tested it with random data and it works just fine. This just looks for dates in the previous 10 days. If so, it is Hot, otherwise Cold. I didn't bother changing future dates to show something different.
Please post a link to your model or a more complete set of data than screenshots to help with the merge issue.