Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
Please advise
Example:
I hope you are creating it as a column and IsWeekend is also a column. And data time is the whole number.
Weekend = IF (Table[IsWeekend] =1, "Yes", "No")
Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blog -
Winner-Topper-on-Map-How-to-Color-States-on-a-Map-with-Winners , HR-Analytics-Active-Employee-Hire-and-Termination-trend
Power-BI-Working-with-Non-Standard-Time-Periods And Comparing-Data-Across-Date-Ranges
Connect on Linkedin
Hi @Heinre
it's because of data type
if your column IsWeekend has the Number type you should compare it without quotas =1
If IsWeekend is a text type you should compare it with quotas ="1"
or try
Weekend = IF (VALUE(IsWeekend) =1, "Yes", "No")
or
Weekend = IF (IsWeekend=VALUE("1"), "Yes", "No")
do not hesitate to give a kudo to useful posts and mark solutions as solution
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
23 | |
21 | |
20 | |
13 | |
12 |
User | Count |
---|---|
43 | |
31 | |
24 | |
23 | |
22 |