Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
AI14
Helper III
Helper III

measure not updating

Hi

 

i have 1 measure in my report that pulls through data whenever it wants lol no matter what i do it works when it wants. 

im not sure if its the data but it cant be because my other measures that use the same data updates just fine.

 

i have a column called AM/PM and it pulls through as AM if another column is below 13:50pm and PM is after

 

= Table.AddColumn(#"Filtered Rows", "AM/PM", each if [Time] <= RDate then "AM" else "PM")

 

RDate is a query i reference for the date and time: = Date.From(DateTime.LocalNow()) & Time.FromText("13:50:00")

 

please help.

3 REPLIES 3
AI14
Helper III
Helper III

both in date/time 

 

the  AM/PM column is in text.

 

the formula works fine in the query and AM or PM shows acccordingly but it does shown't on the multicard visual

 

AI14_0-1674992760773.png

 

Hi @AI14 ,

 

Your query works in myside, please share more details with me.

RicoZhou_0-1675061731395.png

RicoZhou_1-1675061786376.png

 

Best Regards,
Rico Zhou

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

Greg_Deckler
Super User
Super User

@AI14 What are the data types of [Time] and RDate?


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors